\n\tSELECT CASE WHEN TDT.database_id = 32767
\n\tTHEN ‘MSSQLSystemResource’
\n\tELSE DB.name END AS DatabaseName
\n\t,REQ.start_time AS ReqStart
\n\t,TAT.transaction_begin_time AS TransBegin
\n\t,TAT.name AS TransName
\n\t,CASE TDT.database_transaction_type
\n\tWHEN 1 THEN N’Read\/Write’
\n\tWHEN 2 THEN N’Read-only’
\n\tWHEN 3 THEN N’System’
\n\tELSE N’Unkown’ END AS TransType
\n\t,CASE TAT.transaction_state
\n\tWHEN 0 THEN N’Not initialized’
\n\tWHEN 1 THEN N’Not started’
\n\tWHEN 2 THEN N’Active’
\n\tWHEN 3 THEN N’Ended’
\n\tWHEN 4 THEN N’DTC active’
\n\tWHEN 5 THEN N’Preparing’
\n\tWHEN 6 THEN N’Committing’
\n\tWHEN 7 THEN N’Being rolled back’
\n\tWHEN 8 THEN N’Rolled back’
\n\tELSE N’Unkown’
\n\tEND AS TransState
\n\t,REQ.[status] AS ReqStatus
\n\t,TDT.database_transaction_log_record_count AS LogRec
\n\t,TDT.database_transaction_log_bytes_used AS LogBytes
\n\t,SES.login_name AS LoginName
\n\t,REQ.wait_type AS ReqWaitType
\n\t,REQ.percent_complete AS [ReqCompl%]
\n\t,REQ.command AS ReqCommand
\n\t,SUBSTRING(EST.text
\n\t,1 + REQ.statement_start_offset \/ 2
\n\t,(CASE WHEN REQ.statement_end_offset = -1
\n\tTHEN LEN(convert(nvarchar(max), EST.text)) * 2
\n\tELSE REQ.statement_end_offset END – REQ.statement_start_offset) \/ 2
\n\t) AS SqlStatement
\n\tFROM sys.dm_tran_active_transactions AS TAT
\n\tINNER JOIN sys.dm_tran_database_transactions AS TDT
\n\tON TAT.transaction_id = TDT.transaction_id
\n\tINNER JOIN sys.databases AS DB
\n\tON TDT.database_id = DB.database_id
\n\tLEFT JOIN sys.dm_tran_session_transactions AS TST
\n\tON TAT.transaction_id = TST.transaction_id
\n\tLEFT JOIN sys.dm_exec_requests AS REQ
\n\tON TAT.transaction_id = REQ.transaction_id
\n\tLEFT JOIN sys.dm_exec_sessions AS SES
\n\tON REQ.session_id = SES.session_id
\n\tCROSS APPLY sys.dm_exec_sql_text(REQ.sql_handle) AS EST
\n\tWHERE TAT.transaction_id > 255
\n\tAND ISNULL(REQ.session_id, -1) <> @@SPID
\n\tAND TDT.database_id <> DB_ID(N’tempdb’)
\n\tORDER BY DatabaseName
\n\t,TransBegin
\n\t,TransName;<\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT CASE WHEN TDT.database_id = 32767 THEN ‘MS […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2025","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2025"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2025\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}