Hey Old Hand,

The referenced link in the question reference http://support.microsoft.com/kb/171224

says that:

APPLIES TO

Microsoft SQL Server 6.0 Standard Edition

Microsoft SQL Server 6.5 Standard Edition

But in your article you attribute the question to SQL 2005. When I run the dbcc command on the 2005 server this is what I see:

Msg 207, Level 16, State 1, Line 1

Invalid column name 'SUID'.

This column having migrated to UID in SQL 2005.

But even after trying to modify the script for UID to use the DBCC PSS statement I get:

Msg 2526, Level 16, State 3, Line 1

Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.

So it would appear that the functionality for the non-supported process is gone.

So I think today's question might need a bit of brushing up. Or at least some clarifying if you don't mind.

😉