Click to See Complete Forum and Search --> : Knowing Transaction level


trends
October 15th, 2005, 01:12 AM
Hi evrybody,

Is there any system SP to know the transaction level in sql server.

hspc
October 18th, 2005, 02:40 PM
Use the global function:
@@TRANCOUNT
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_globals_8lx0.asp