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

335 reads

Blogs

Copying large files from SharePoint Online

By

I recently worked on a project where we needed to copy some large files...

How Long has Your SQL Server Been Online

By

This week’s blog post will help you check your SQL Servers up-time. There are...

The less you hear from or about the DBAs the better they are doing their job.

By

Something I’ve been thinking about recently is that DBAs are best when they are...

Read the latest Blogs

Forums

Ordering String_Split()

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering String_Split()

Worse Before Better

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Worse Before Better

Azure SQL Managed Backup for on-prem databases

By database diva

I have a SQL 2017 on-prem database server that the client wants to back...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers