Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbcc showcontig
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Miscellaneous
Thread ID:
00723260
Message ID:
00723407
Views:
8
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
Previous
Reply
Map
View

Click here to load this message in the networking platform