May 12, 2004 at 3:42 pm
Hello:
I am trying to run dbcc showcontig command with tableresults and all_indexes options. But I get error message 'ALL_INDEXES ' is not a recognized option.' I tried other options also as given in BOL for this command but the same problem.
I am giving the command as follows:
USE pubs
DBCC SHOWCONTIG WITH TABLERESULTS , ALL_INDEXES (as given in BOL)
Your help will be greatly appreciated.
Thank you
May 12, 2004 at 4:57 pm
Try
USE pubs
DBCC SHOWCONTIG (titleauthor) WITH TABLERESULTS , ALL_INDEXES
DBCC SHOWCONTIG (titleauthor,UPKCL_taind) WITH TABLERESULTS
May 13, 2004 at 7:31 am
I tried the above commands. If I try either first command line or both I get error:
''ALL_INDEXES' is not a recognized option.'
If I try second command line I get:
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.
This is what happening. I have tried this way also which is given in BOL.
Thank you
May 13, 2004 at 4:29 pm
Execute and post the result from
Select @@Version
USE pubs
GO
DBCC SHOWCONTIG (titleauthor)
DBCC SHOWCONTIG (titleauthor,UPKCL_taind)
GO
May 13, 2004 at 4:34 pm
Second thoughts, rather use the quoted version!
Select @@Version
USE pubs
GO
DBCC SHOWCONTIG ('titleauthor')
DBCC SHOWCONTIG ('titleauthor','UPKCL_taind')
GO
May 14, 2004 at 2:26 am
What version of Sql Server? 7.0 did not come with these options...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply