What's the exact DBCC DBREINDEX command that you're running and what error is it giving you?

Is this SQL 2005? (I assume it is, seeing as it's posted in the 2005...

Sadequl Hussain (5/16/2009)

---

This is because the checkpoint process - the process that writes to data files from the log will start with a BEGIN TRANS in the log file and...

Just be aware that you may have lost data due to the log rebuild. Transactions that were committed, but whose changes were not hardened to disk when the log was...

Indexes on bit columns work the same way as indexes on any other column type. Have a look at this blog post.

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

I liked the one where they thought they had backups, deleted...

Or run profiler that will capture everything that runs on the system while the trace...

Are those procs? If so, script them, drop them and then recreate them.

Nor among any of my paying clients.

I was born not far from there.

Back to the subject of questions...

There must have been 8-10 questions on database corruption in the last week or two. Is it open season on corruptions all of a sudden?...

Ok, in that case you have to let the checkDB finish. There is no manual steps that you can take, you're already doing them.

See the link that I posted...

Use the object_name function.

So, to get all the objects involved, you would run this

SELECT Object_Name(16823222)

SELECT Object_Name(16055143)

SELECT Object_Name(32823279)

SELECT Object_Name(48823336)

The reason you weren't getting these on SQL 2000 is that CheckDB there...

If that operation succeeded, there is a full backup somewhere. If there was no backup at all, the log backup would have failed with an error like "No current backup...

Contrary to popular belief, TRUNCATE TABLE is a logged operation. It's minimally logged (page deallocations), but it is...

Do you by any chance have the last full backup that was made? If the...