We find nothing wrong with data and are not opposed to rebuilding the entire index this weekend.

We are having compellant look into it. The only thing that happened Monday morning was the restoring of the database from production system in preparation of the switch to...

If you have an opportunity could you please give an opinion on this one also that happen a couple of days ago. The mapped drives are SAN based.

2000 RESULTS

Server: Msg 8951, Level 16, State 1, Line 1

Table error: Table 'AssignmentRoot' (ID 1286229770). Missing or invalid key in index 'idx_AssignmentRoot_RepName' (ID 70) for the row:

Server: Msg 8955,...

Restored to 2008 this a.m.

No errors using DBCC CHECKCATALOG

DBCC CHECKDB reurned the following:

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed:...

Thanks Gail. I planned to do just that in the a.m.

P.S.

I love your articles.

All errors are gone.

Thanks for everyone's help.

There are 3 distinct id in the error list. In examining them on older database it has been determined that they are pre 2005 tables.

that works..will advise results

Thanks

Running DBCC CHECKCATALOG ('TWORKS') WITH NO_INFOMSGS produces some errors as follows:

Server: Msg 2513, Level 16, State 2, Line 1

Table error: Object ID 544525519 (object '544525519') does not match between...

SQL 2000

SELECT Object_Name(544525519) returns a NULL record. I have about 3 of them. How can I get rid of them?

Perry

I took your suggestion and did a

DBCC UPDATEUSAGE (0)

and

DBCC CHECKDB WITH data_purity, all_errormsgs, NO_INFOMSGS

as I am porting to 2008 in a couple of weeks.

I got the error

Msg 8992, Level...

I took your advice and did DBCC CHECKCATALOG on production as we are moving it to 2008.

so what exactly does the moving mean and how do I correct it?

Server: Msg...

They are all in a normal state as I rebuildt yesterday. I going to write a script to check on db status and notify accordingly. The mapped drives...