Saturday, February 25, 2012

DBCC DBREINDEX

I am trying to do something very simple, that is to
reindex table in a database with the following command in
SQL Query Analyser;
dbcc DBREINDEX (activitylog, '', 0)
I get the following message:
Server: Msg 2501, Level 16, State 1, Line 1
Could not find a table or object named 'activitylog'.
Check sysobjects.
I know the table activitylog exists.
Please help !Perhaps incorrect owner? Make sure you include the owner...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Amar" <amar.pabla@.wanneroo.wa.gov.au> wrote in message
news:1adbe01c387e8$ec52aef0$a601280a@.phx.gbl...
> I am trying to do something very simple, that is to
> reindex table in a database with the following command in
> SQL Query Analyser;
> dbcc DBREINDEX (activitylog, '', 0)
> I get the following message:
> Server: Msg 2501, Level 16, State 1, Line 1
> Could not find a table or object named 'activitylog'.
> Check sysobjects.
> I know the table activitylog exists.
> Please help !
>|||Amar
Try
use dbname
dbcc DBREINDEX (activitylog, '', 0)
If that does not work try
dbcc DBREINDEX (dbname.tableowner.activitylog, '', 0)
Obviouslt substituting your dbname and tableowner where
applicable.
Hope this helps
John

No comments:

Post a Comment