Lowell, Thanks for this, you saved me a bunch of work this week. I had a couple vendor installed databases that had wrong collation. I was able...

I finally found my answer to this question with the following white paper:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

It states:

All work done by DBCC DBREINDEX occurs as a single, atomic transaction. The new indexes must...