no row in sysobjects table

  • 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.

  • 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.

  • 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 2 (of 2 total)

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