SQL Transactions Archives - Page 5 of 5 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT

September 25, 2007

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Transactions

What is the effect of a TRANSACTION on local variable values after ROLLBACK and after COMMIT? A short example I wrote for a Jr. Developer shows the answer.

SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

April 12, 2007

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security, SQL Transactions

An SSIS package fails with Error 3902: the COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. Two fixes, one is RetainSameConnection set to true.