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

Meet BootUI | Scan AI-Generated Code & Find What AI Missed !

 very usefull link to verify ai content https://www.youtube.com/watch?v=pULGt0Rme58 Click