Summer90
SSC-Dedicated
Points: 32891
More actions
January 18, 2011 at 1:18 pm
#232328
There are no other connections to this database and a large delete is running.... When I run the SP_WHO2 with the SPID it shows BlkBy -3 what is a negative SPID mean? I have never seen a negative number show up for a blocking request....
January 18, 2011 at 2:11 pm
#1274979
I found the answer: Deferred transaction recovery is blocking it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply