to know pending transaction use below querys
SELECT * FROM sys.sysprocesses WHERE open_tran = 1
SELECT * FROM sys.sysprocesses WHERE open_tran <> 0
Exec sp_Who2 79
exec sp_lock 79
KILL 79
very usefull link to verify ai content https://www.youtube.com/watch?v=pULGt0Rme58 Click
No comments:
Post a Comment