SQL-Server-2005

SQL-Server

SQL-Server-2008

database

How to get the details of Open Transaction in SQL Server

tarun_j200

Rate me:

Please Sign up or sign in to vote.

4.75/5 (3 votes)

2 Sep 2010CPOL 61.9K   3   5

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

SQL

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)

Written By

tarun_j200

 India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

First Prev Next

How to identify open transactions in SQL Server Dilip Kr. Singh22-Sep-15 19:36 Dilip Kr. Singh 22-Sep-15 19:36  You can use following queries. 1-SELECT * FROM SYS.SYSPROCESSES WHERE OPEN_TRAN = 1 2-SELECT * FROM SYS.DM_TRAN_SESSION_TRANSACTIONS to know more [Click Here] modified 23-Sep-15 2:30am. nice beffes10-Nov-10 0:34 beffes 10-Nov-10 0:34  nice Good Tip.......... Vivek Johari6-Sep-10 20:42 Vivek Johari 6-Sep-10 20:42  Good Tip..........

Last Visit: 31-Dec-99 18:00     Last Update: 25-Apr-24 2:04 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.