Skip to content

Working with transactions

You SHOULD pair each BEGIN TRANSACTION with a COMMIT or ROLLBACK TRANSACTION (and vice versa.) Open transactions can cause applications to fail if left unchecked.

You SHOULD NOT:-

  • Perform cross database transactions even where SQL Server supports them.

  • Perform cross server queries (using linked servers or OPENQUERY1.)

  • Perform cross database queries in mirrored environments. They will fail should database failover occur2.

Further reading and information

Transactions: availability groups & database mirroring - SQL Server Always On | Microsoft Learn

  1. This should be resolved in the application design. ↩

  2. Although you may consider this an acceptable risk. ↩