Solution: Execute the following statement :
SELECT DISTINCT blocking_session_id
FROM sys.dm_exec_requests AS r
WHERE NOT EXISTS (SELECT 1
FROM sys.dm_exec_requests r2
WHERE r.blocking_session_id = r2.session_id
AND r2.blocking_session_id > 0)
AND r.blocking_session_id > 0 ;
GO
Keine Kommentare:
Kommentar veröffentlichen