First off - this is a volunteer forum, not a service you're paying for - so don't hassle people to hurry up...

Note: This question was written by Kimberly.

CHECKDB of tempdb on 2000 doesn't really do much - so unsurprising it doesn't show any errors.

No problem. I really need to get around to writing a really detailed, comprehensive guide to corruption - nothing out there right now.

For the page latch message - when the final PFS page at the end of the file is damaged (which could be the case here), I couldn't tell how many...

Ah - forgot we were in the 7.0/2000 forum. Indeed - I rewrote most of that code for 2005 - removing all kinds of weird behavior.

No workaround I'm afraid, except...

Hmm - it works perfectly well for me on an SP3 system...

create database foo

go

use foo

go

create table t1 (c1 int identity, c2 int)

go

insert into t1 values (1)

insert into t1 values (2)

go

alter...

Repair_rebuild fixes problems with non-clustered indexes, including forcing index rebuilds to rescan the base table.

What are the corruptions? (i.e. output from DBCC CHECKDB (yourdb) WITH NO_INFOMSGS, ALL_ERRORMSGS

Thanks

But that is expected behavior - the RESEED has to update the system catalogs to reflect the new next-identity value - which it can't do on a read-only databaase.

Why on earth would you advise doing that? You don't even know why the...

I just created your scenario and I had no problem dropping the database using a DROP DATABASE command. 2005 SP3.

What method are you trying to use and what error do...

Well, the output from sys.databases tells you why the log can't clear. For instance, if it says LOG_BACKUP it means you've got to take a log backup before the log...

No idea. At this point you should call Product Support to help you.

Here's the link you need to rebuild them: http://msdn.microsoft.com/en-us/library/dd207003.aspx

Never, never, never detach a suspect database.

Automatically creating a new log file is only possible when the database is cleanly shutdown - otherwise the database knows that it needs the log file to run crash recovery.

If...