Error !

I am using the following command but it gave me an error
dbcc checktable ('testing') with REPAIR_REBUILD
Server: Msg 195, Level 15, State 4, Line 1
'REPAIR_REBUILD' is not a recognized option.
Thanks
Noor
Hi,
I think you are executing this option (DBCC CHECKDB with REPAIR_REBUILD) in
a SQL Server
version prior to SQL 2000.
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:eDUdWjZXEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I am using the following command but it gave me an error
> dbcc checktable ('testing') with REPAIR_REBUILD
> Server: Msg 195, Level 15, State 4, Line 1
> 'REPAIR_REBUILD' is not a recognized option.
> Thanks
> Noor
>
|||Hi,
I think you are executing this option (DBCC CHECKDB with REPAIR_REBUILD) in
a SQL Server
version prior to SQL 2000.
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:eDUdWjZXEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I am using the following command but it gave me an error
> dbcc checktable ('testing') with REPAIR_REBUILD
> Server: Msg 195, Level 15, State 4, Line 1
> 'REPAIR_REBUILD' is not a recognized option.
> Thanks
> Noor
>
|||IN SQL 2000, you'd want to do
dbcc checktable ('mytable',REPAIR_REBUILD)
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.