Find All Code with Rollback Tran but No Begin Tran

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 […]

2006-01-09 (first published: )

330 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

is there anyway to send an email if no record has been submited during the day

By skaailet

I want to send an email if the table in SQL hasn't been update...

First DW design - advice appreciated

By as1981

All, Up to this point I've only worked with relational databases. I'm trying to...

Backup Strategy For distributed availability groups

By juniorDBA13

What is the recommendations for backups in distributed availability groups? I have AG setup...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers