Categories
One-liners SQL Server

Useful SQL Server One-Liners

Quick way to check if your current session is in AUTO-COMMIT mode:
 

1
SELECT (2 & @@OPTIONS)  --- SET IMPLICIT TRANSACTIONS: 0 = OFF, 2 = ON

1 reply on “Useful SQL Server One-Liners”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.