Technical Article

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: )

336 reads

Blogs

Techorama 2022 Slides

By

I had a great time at Techorama. I’ll do a writeup on the event,...

Daily Coping 27 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Load balancing IPv6 UDP

By hasanobts

It seems that none of the cloud providers have internal load balancers that can...

Beginner Question about Azure SQL Database and Source Control (Azure Dev Ops)

By pakhitepo

Hi guys, I hope someone of you has the time to help me. I...

The 2022 Preview

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The 2022 Preview

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers