I was having problem with my database, I couldn't see any of the table in the enterprise manager. when I execute any sql in some of the tables of the database it was giving error msf that "Bad Page Id".
I went through the FAQs and Forums, I tried with this queries.
ALTER DATABASE DMS_PILOT SET SINGLE_USER
DBCC CHECKDB (DMS_PILOT, REPAIR_ALLOW_DATA_LOSS)
When I execute this query I found some new error messeges mentioned as below.
"Server: Msg 8966, Level 16, State 1, Line 2
Could not read and latch page (1:3168) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator."
Please help me.
View Complete Post