DECLARE @lockTable AS TABLE(spid INT,[dbid] INT,objId BIGINT,
indId INT,Type NVARCHAR(10),resource NVARCHAR(20),
Mode NVARCHAR(5), STATUS NVARCHAR(20))
indId INT,Type NVARCHAR(10),resource NVARCHAR(20),
Mode NVARCHAR(5), STATUS NVARCHAR(20))
INSERT INTO @lockTable
EXEC sp_lock
SELECT * FROM @lockTable
WHERE Mode LIKE '%X%'--x =lock
AND db_name([objid])='databaseName'
No comments:
Post a Comment