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
Subscribe to:
Post Comments (Atom)
-
Points 1.complex page layouts and adherence to code standards. 2.primeNG pagination 3.ngcontent 4.ngdestory(memorylekage) 5.datatransfer wi...
-
Check duplicate count based on 3 columns combo select EMPID,FORMinfoID,FormName,Count(*) as counts from tbl_FilesMigrationLogs group by Em...
No comments:
Post a Comment