Home Forums SQL Server 2008 SQL Server 2008 - General DELETE statement won't complete RE: DELETE statement won't complete
Suresh B.
SSC-Insane
Points: 22986
More actions
September 17, 2012 at 1:36 am
#1538426
There may be blocking issue. Please run the following query to confirm:
select status, blocking_session_id, wait_type, wait_resource
from sys.dm_exec_requests
where session_id = <spid>