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.
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.