Quick way to check if your current session is in AUTO-COMMIT mode:
1 | SELECT (2 & @@OPTIONS) --- SET IMPLICIT TRANSACTIONS: 0 = OFF, 2 = ON |
Categories
Quick way to check if your current session is in AUTO-COMMIT mode:
1 | SELECT (2 & @@OPTIONS) --- SET IMPLICIT TRANSACTIONS: 0 = OFF, 2 = ON |
One reply on “Useful SQL Server One-Liners”
Awesome information. I really appreciate a writer who is thorough. I look forward to reading more of your work in the future.