Detect an active transaction
How to detect an active transaction in a database.
DBCC SQLPERF (LOGSPACE)
SELECT name, log_reuse_wait_desc
FROM sys.databases
DBCC OPENTRAN
EXEC sp_who2
DBCC INPUTBUFFER (51)
KILL 71
DBCC SQLPERF (LOGSPACE)
SELECT name, log_reuse_wait_desc
FROM sys.databases
DBCC OPENTRAN
EXEC sp_who2
DBCC INPUTBUFFER (51)
KILL 71