Opinionated Software

… we have opinions about everything!

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

Categorised as: One-liners | SQL Server


One Comment

  1. Billy Melnyk says:

    Awesome information. I really appreciate a writer who is thorough. I look forward to reading more of your work in the future.

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.