DBCC Showcontig

[Richard]

I was attempting to run the dbcc command on a couple of my databases and I get some errors on some servers but not others. Is there a reason for this?
What am I doing wrong? Is there a server setting that stops dbcc commands?

Here are the commands and errors

dbcc showcontig

Server: Msg 2583, Level 16, State 3, Line 1
An incorrect number of parameters was given to the DBCC statement.

dbcc showcontig (PS_ABS_HIST_COM_UK)

Server: Msg 2560, Level 16, State 14, Line 1
Parameter 1 is incorrect for this DBCC statement.

[Ray Miao]

Check books online for syntax.


------------
Richard at 5/7/2002 2:08:43 PM

I was attempting to run the dbcc command on a couple of my databases and I get some errors on some servers but not others. Is there a reason for this?
What am I doing wrong? Is there a server setting that stops dbcc commands?

Here are the commands and errors

dbcc showcontig

Server: Msg 2583, Level 16, State 3, Line 1
An incorrect number of parameters was given to the DBCC statement.

dbcc showcontig (PS_ABS_HIST_COM_UK)

Server: Msg 2560, Level 16, State 14, Line 1
Parameter 1 is incorrect for this DBCC statement.

[Richard]

I copied the syntax from books online. Also, the same command, (dbcc showcontig), works on one server but not several others. Some of my servers are SQL 2000 and others are SQL 7. But the results are the same regardless!


------------
Ray Miao at 5/7/2002 3:15:22 PM

Check books online for syntax.


------------
Richard at 5/7/2002 2:08:43 PM

I was attempting to run the dbcc command on a couple of my databases and I get some errors on some servers but not others. Is there a reason for this?
What am I doing wrong? Is there a server setting that stops dbcc commands?

Here are the commands and errors

dbcc showcontig

Server: Msg 2583, Level 16, State 3, Line 1
An incorrect number of parameters was given to the DBCC statement.

dbcc showcontig (PS_ABS_HIST_COM_UK)

Server: Msg 2560, Level 16, State 14, Line 1
Parameter 1 is incorrect for this DBCC statement.

[Venu]

Richard,

Try to give the Object ID as a Parameter.

Get the Object_ID First
- SELECT OBJECT_ID('Your_Table_Name)
GO
- DBCC SHOWCONTIG(1652305046)
-- The Parameter above is the Object ID

Good Luck
Venu


------------
Richard at 5/7/2002 3:19:33 PM

I copied the syntax from books online. Also, the same command, (dbcc showcontig), works on one server but not several others. Some of my servers are SQL 2000 and others are SQL 7. But the results are the same regardless!


------------
Ray Miao at 5/7/2002 3:15:22 PM

Check books online for syntax.


------------
Richard at 5/7/2002 2:08:43 PM

I was attempting to run the dbcc command on a couple of my databases and I get some errors on some servers but not others. Is there a reason for this?
What am I doing wrong? Is there a server setting that stops dbcc commands?

Here are the commands and errors

dbcc showcontig

Server: Msg 2583, Level 16, State 3, Line 1
An incorrect number of parameters was given to the DBCC statement.

dbcc showcontig (PS_ABS_HIST_COM_UK)

Server: Msg 2560, Level 16, State 14, Line 1
Parameter 1 is incorrect for this DBCC statement.