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

API run block issue run api from cmd

  ✅ Debug Checklist – “Access is Denied” (.NET / Visual Studio) 🔹 Identify Problem ☐ Error: Unable to start program (.exe) – Access is deni...