Nov
21
2007
MsSQL Rant 2: Context transaction [blah blah blah] enforce strict transaction nesting.
Posted by: ThatOneGuy in ProgrammingIf you’ve worked with building a CLR trigger for MsSQL, then there are decent odds you’ve seen this come back to the message window while testing the trigger inside Microsoft SQL Management Studio:
Tags: Catch, CLR trigger, MsSQL, SqlContext, transaction, transaction nesting, trigger, TryThe context transaction which was active before entering user defined routine, trigger or aggregate “[CLR trigger name]” has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting.



Entries (RSS)