1. thiagesh New Member

   Hi
   I'm new to SQL SERVER. Just want to know, how to see the current value set for IMPLICIT_TRANSACTIONS.
   Is there any sys table/view, where we can get the values set.
   Thanks.
   

   thiagesh, Jan 25, 2011

   #2
2. satya Moderator

   Welcome to the forums.
   SEe http://msdn.microsoft.com/en-us/library/ms188317.aspx documentation which refers about default behaviour of SQL SErver. Implicit transaction mode is not SQL Server's default. You have to request implicit transaction mode either with a SET statement.
   Also issues when used http://sqlserverpedia.com/blog/sql-server-bloggers/implicit-transactions-and-the-performance-issue/ link.
   

   satya, Jan 25, 2011

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in