Howdy Ya’ll!

It seems as the article (http://support.microsoft.com/kb/271509) and the
scripts were modified in the last few years. Somewhere along the way
sp_blocker_pss80 was renamed to sp_blocker_pss08, which is fine – no harm
there. The location where you create the stored procedure in question was
changed as well. If I recall it correctly, older editions of this article
used master DB, now you use tempdb.

Please update step 2 to reflect correct location of sp_blocker_pss08 stored
procedure. It should be:

WHILE 1=1
BEGIN
EXEC tempdb.dbo.sp_blocker_pss08
-- Or for fast mode
-- EXEC tempdb.dbo.sp_blocker_pss08 @fast=1
-- Or for latch mode
-- EXEC tempdb.dbo.sp_blocker_pss08 @latch=1
WAITFOR DELAY '00:00:15'
END
GO

Thank you,
Olegas