filmov
tv
How to Get locked Objects in SQL Server

Показать описание
Generally, There are two ways to get what are the objects are Locked. First way with SP_LOCK, We can get the Locked Object details in a Particular Session Or SQL Server Engine.
To Get Locked Objects
-----------------------------------
With Requested SQL Server Statement
-------------------------------------------------------------
Where spID = SessionID