O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Transactions in SQL CLR (CLR Integration)

No chapter on transactions is complete without a discussion of transactions in SQL CLR. Transactions behave so differently in the SQL CLR that this topic warrants its own section.

So far, we have discussed local transactions in SQL Server and ADO.NET, as well as distributed transactions in ADO.NET, SQL Server, and the .NET Framework in general. We noted that in PSPE, a distributed transaction might not be distributed. Thus, the boundaries of what is distributed and what is not are already blurry. Well, in SQL CLR, they are not only blurry, they are downright indistinct.

In Chapter 3, you learned about the basics of SQL CLR. We will build on the same concepts here and write a simple SQL CLR stored procedure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required