Monday, July 1, 2019

How to check uncommitted transaction in SQL Server

This is to see the uncommitted transaction and kill that transaction.

SELECT OBJECT_NAME(P.object_id) AS TableName, Resource_type, request_session_id 
FROM sys.dm_tran_locks L
INNER JOIN sys.partitions P ON L.resource_associated_entity_id = p.hobt_id

OR

DBCC OPENTRAN

commit transaction process_commission_upsert

kill 60

No comments: