September 8, 2001 at 8:28 pm
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.
September 8, 2001 at 8:31 pm
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.
September 8, 2001 at 10:27 pm
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