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

HCL healthcare

 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...