Posts
485
Comments
400
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:

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
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 6 and 1 and type the answer here: