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
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:
Post a Comment