Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Find All Code with Rollback Tran but No Begin Tran

By Brian Laws,

This simple script identifies all objects which have a rollback transaction statement without a requisite begin transaction statement. If a rollback statement is issued without a begin statement, then the code will generate an error. Triggers are not included in the list since they can have a rollback without a begin.

This script can be easily modified to be used for any other code search where something exists in the code but another thing doesn't. With other modifications, it can be used for other purposes, such as finding all tables which are not being acessed in any other piece of code.

I hope this helps!

Total article views: 326 | Views in the last 30 days: 3
 
Related Articles
FORUM

Begin Transaction question

begin tran without commit/rollback

FORUM

ROLLBACK Transaction

ROLLBACK Transaction

FORUM

Rollback

How to use Transactions for rollback

FORUM

Rollback in SSIS

Rollback

FORUM

Commit/Rollback inner transactions

Commit/Rollback inner transactions

Tags
 
Contribute