Does anyone know of any way to list open transactions on SQL Server 2000 database?
I am aware that I can query the view sys.dm_tran_session_transactions
on SQL 2005 (and later) database versions, however this is not available on SQL 2000.
Advertisement
Answer
For all databases query sys.sysprocesses
SELECT * FROM sys.sysprocesses WHERE open_tran = 1
For the current database use:
DBCC OPENTRAN