Wednesday, 13 March 2024

Transaction in sql

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

No comments:

Post a Comment

dropdownsearch for dyanmic fields

    I’ve enabled searchable dropdowns for all dynamic dropdown controls in Assignment Details. What I changed Added a  dropdownSearch  map...