Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (20.3k points)

Does anyone know of any way to list open transactions on the 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.

1 Answer

0 votes
by (40.4k points)

For all databases, you can use sys.sysprocesses query like this:

SELECT * FROM sys.sysprocesses WHERE open_tran = 1

For the current database, try this:


Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers


94k users

Browse Categories