Blocking condition? SQL 2005

Last Post 18 Jan 2011 12:09 PM by Markus_SQL. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Markus_SQL
New Member
New Member

--
18 Jan 2011 11:18 AM
I have a delete running in a SQL 2005 DB and there are no other connections into the application database.  When I run the SP_WHO2 with the SPID I see a  -3 in the BlkBy and the SPID is in SUSPENDED mode.  What does a negative number mean?  I have never seen this before.


Markus_SQL
New Member
New Member

--
18 Jan 2011 12:09 PM
I found the answer:  deferred transaction recovery.


Acceptable Use Policy
---