How to get the details of Open Transaction in SQL Server

The below query can be used to get the details of OPEN TRANSACTION:

SELECT DB_NAME(dbid) AS DBNAME, (SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS SQLSTATEMENT FROM master..sysprocesses WHERE open_tran > 0

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

tarun_j200

India

Member

No Biography provided

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

		9,890,640 members (46,699 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using