If 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:

The 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.

Read the rest of this entry »

Tags: , , , , , , ,

Comments 2 Comments »

Ok… so this is getting really frustrating:

WHY does MsSQL not have support for a LIMIT?

Don’t get me wrong, there are many wonderful things about working with the Microsoft .NET environment, including MsSQL and Visual Studio .NET… but there could be some improvements. Read the rest of this entry »

Tags: , , , , , , ,

Comments 2 Comments »

ThatOneGuy is back.

Odds are there will be a blog filled with mostly programming ramblings, but you never know.

That is all for now…

Comments No Comments »