no row in sysobjects table

  • graceb

    SSChasing Mays

    Points: 624

    Server: Msg 906, Level 22, State 2, Line 1

    Could not locate row in sysobjects for system catalog 'Sysobjects' in database 'heat'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.

  • graceb

    SSChasing Mays

    Points: 624

    The error was created when I use:

    sp_attach_single_file_db 'heat', 'c:\mssql7\data\heat_data.mdf'

    I ran"

    dbcc checktable ('systables') and got:

    DBCC results for 'sysobjects'.

    There are 120 rows in 2 pages for object 'sysobjects'.

    My email is gbarr@czn.com, please kindly

    copy me.

  • Andy Warren

    SSC Guru

    Points: 119676

    I'd suggest trying dbcc checkdb first. If that doesn't help, it maybe that the mdf is corrupt. Try using another copy of it or restoring one from backup, then drop the one you have now and try again.

    Andy

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply