Hi George,
I believe the second parameter should be an integer. Try :
DBCC SHOWCONTIG('auction_status', 0)
0 or the ID number for the index in question.
No longer at Frost huh?
>Can anyone see what in the world I am doing wrong here? I am trying to run this command:
>
>DBCC SHOWCONTIG('dbo.auction_status', 'PK_auction_status') WITH TABLERESULTS
>
>and I am receiving these results:
>
>Server: Msg 2560, Level 16, State 14, Line 1
>Parameter 2 is incorrect for this DBCC statement.
>Server: Msg 2560, Level 16, State 1, Line 1
>Parameter 1 is incorrect for this DBCC statement.
>
>I have been pulling my hair out for two days and cannot find out what is wrong with the above syntax. What in the world am I missing?
>
>TIA,
>George