Lab Sql

Can someone shed light on what is happening behind the scenes with the SQL Lightweight transaction … Read more .net Transactionscopes And Sql 2005 Lightweight Transaction Manager - Multiple Connections Same Spid?

I am getting this error The transaction must be disposed before the connection can be used to exe… Read more The Transaction Must Be Disposed Before The Connection Can Be Used To Execute Sql Statements

My current understanding of transactionscope timeouts. If a transaction has been running longer th… Read more Understanding Transactionscope Timeouts

A while back I asked a question about TransactionScope escalating to MSDTC when I wasn't expect… Read more Transactionscope Helper That Exhausts Connection Pool Without Fail - Help?

I use TransactionScope in this code: private void ExecuteSP() { bool IsComplete = false; Sq… Read more Transactionscope Maximumtimeout

I'm using TransactionScope to make a method that contains multiple sql statements transactional… Read more Transactionscope And Method Call That Uses The Same Connection