Paige
SSC Rookie
Points: 31
More actions
May 4, 2005 at 9:04 am
#87409
When executing sp_who2, we noticed some blocking. A spid was being blocked by '-2' I could find no reference to a -2 in my search and was wondering if anyone had experienced it and what you did to prevent it from occuring again. TIA
Nicholas Cain
SSC-Dedicated
Points: 33009
May 4, 2005 at 10:11 am
#556825
It seems as though the process is being blocked by an orphaned distributed transaction.
See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_wa-wz_3v8v.asp for more details.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply