February 10, 2006 at 12:37 pm
I have recently run a DBCC CHECKDB on a database that I have and the command completes with out errors. On the same database I ran a DBCC CHECKTABLE and I receive the following error:
Server: MSG 2501, Level 16, State 1, Line 1
Could not find a table or object named 'TABLE'. Check sysobjects.
When I look in sysobjects the table is there?
Any help would be extremely appreciated.
February 10, 2006 at 11:07 pm
hi,
are u executing the dbcc checktable command on the right database.
Pls check the database name .
HTH
from
Killer
February 12, 2006 at 4:11 pm
Have you checked to put the name of the owner of the table if it is other than dbo?
February 13, 2006 at 9:36 pm
You have to run as follow
DBCC CheckTable('Tablename')
Try & let me know.
regards
Shifan
shifan
February 13, 2006 at 11:19 pm
Hi,
Plz update Stats before execucting DBCC command.
sp_updatestats
If the same exists plz register the db and check
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply