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
Job Description: Experience working closely with business users/leaders. Well-versed in requirement gathering and can lead business users ...
No comments:
Post a Comment