How to Get locked Objects in SQL Server

preview_player
Показать описание

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
Рекомендации по теме
join shbcf.ru