Post reply

DBCC CheckDB vs DBCC CheckTable

  • February 10, 2006 at 12:37 pm

    #111391

    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

    #620311

    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

    #620343

    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

    #620571

    You have to run as follow

    DBCC CheckTable('Tablename')

    Try & let me know.

    regards

    Shifan

     

     


    shifan

  • February 13, 2006 at 11:19 pm

    #620579

    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