Posts
1150
Comments
891
Trackbacks
1
SQL Server 2000: SPID blocking itself

This is one of those “it's a feature, not a bug” things that was introduced in SP4:

http://support.microsoft.com/default.aspx/kb/906344

Technically, this makes sense, but if you are used to using sp_who2 to check for harmful blocking, this is really rather annoying, as it can look like a process is blocking itself for an extended period of time while it is still doing useful work.

posted on Tuesday, May 23, 2006 4:26 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 2 and 4 and type the answer here: