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

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

A tidy line of wooden artist mannequins where only the last one has a red bucket stuck on its head

Last Line of a SQL Script: The Joke Every DBA Has Lived

May 14, 2007

Pinal Dave

SQL Tips and Tricks

SQL Humor, SQL Scripts, SQL Server Management Studio, SQL Transactions

The last line of a SQL script decides whether your work is saved, rolled back, or still holding locks. Here are the classic endings and how to check them.

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.