Error while inserting data into temp table from CLR fucntion

• brijmailid

  SSC Veteran

  Points: 235

  More actions

  October 8, 2009 at 6:25 am

  #211869

  hi All,

  sql is showing the following error while inserting data into a temporary table:

  Query: SELECT * into #tmp FROM dbo.InterestCalc(@Para1, @Para2)

  ERROR

  The context transaction which was active before entering user defined routine, trigger or aggregate "InterestCalc" has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting

  No transaction has been used in the User defined function "InterestCalc".

  moreover same thing is working on other client.

  Thanks

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  October 8, 2009 at 8:18 am

  #1063485

  Did you debug your clr proc, is it working fine? could be that there is some problem inside that?

  ---------------------------------------------------------------------------------