You'll need to get another CD from Microsoft - call Product Support. It's against the terms of the licensing agreement for anyone to send you (i.e. distribute) any of the...

Are you on 2000 or 2005? Your title says 2000 but you've posted in the 2005-specific forum (there's a 7.0/2000-specific corruption forum too - due to the many differences around...

What exactly are you trying to do?

You're on the right path - as I said before I'm not going to give detailed info on how to do this as its unsupported and I haven't tested it...

This is not supported in any way but you can use the Dedicated Admin Connection to get access to the system tables. I won't explain any more how to do...

I know you're using 2005 - that's where the error came from. Can you read my post and answer the question about upgrading/altering system tables?

Thanks

Well, not too much info to go on, or the normal forum etiquette of please/thank-you but I'll help you anyway.

This is a metadata corruption returned by CHECKDB or CHECKCATALOG. The...

For statistics that aren't on indexed columns, yes, you may want to manually update these if they get out of date and the auto update hasn't kicked in (e.g. if...

Hi,

Which version of 2005 are you using? (include hotfix level)

Can you post the full results of DBCC CHECKDB (yourdb) WITH ALL_ERRORMSGS, NO_INFOMSGS from the restored copy of the backup pre-reindexing...

Well, Steve - it's not that bad. We know how to fix all errors that are detected - there's no guessing involved in repair. What you're thinking of is the...

Sounds like the hardware on the first server is dodgy in some way - if repeated restores on that server result in corruptions but restores on other servers don't, then...

Googling 'SQL server delete duplicate records' brought up a bunch of articles, including http://support.microsoft.com/kb/139444. Search engines are your friends.

Ah - well you did post this in the 2005-specific corruption forum - there's a 7.0/2000 corruption forum too.

If you have backups, now is the time to use them as...

You won't lose any data. This is most likely a single-bit corruption in one of the allocation bitmaps. A GAM page controls whether an extent is available for allocation to...

No worries - no offense taken (ever) - I'm very thick-skinned.

Cheers