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
hcl health care f2f second round interview asked more uestions on microservice 1.apim manage all apis in one place 2.sql profiler in one fo...
No comments:
Post a Comment