ROLLBACK TRANSACTION without BEGIN TRANSACTION

Take notice of using ROLLBACK TRANSACTION without BEGIN TRANSACTION.

It is possible to have a ROLLBACK TRANSACTION within a block where there is no explicit transaction. This will trigger an error if the code is executed outside a transaction, and suggests that transactions are being held open unnecessarily.

Available in

SQL Code Guard