@Gail Yup - especially in Enterprise Edition. And yes, anything with write-access to SQL memory can cause this.

gery.baird (8/25/2009)

---

hii this gerybaird and in my view your problem is related to software corporation please update your software.

Nonsense.

Don't confuse this with an I/O error like 823/824. This error says that the page has a page checksum which was valid when the page was read into memory, but...

Yup - you've got corruption in your 2000 database. Run DBCC CHECKDB (YourDB) WITH ALL_ERRORMSGS, NO_INFOMSGS and also run DBCC CHECKCATALOG (YourDB).

The upgrade step is failing with 601 - clearly...

You've hit a known bug that was just discovered last week. The SQL team is aware of it and it will be getting fixed soon.

Thanks

Sorry - the expert took a while to read email 🙂

Why did you CHECKDB model?

Are you running queries using NOLOCK or read-uncommitted isolation level?

Can you post the T-SQL of the...

@Sankar Well, kind of - BOL doesn't give the internals of much of SQL Server at all.

@rja.carnegie Just because it says restore from a backup doesn't mean you lose your...

No it doesn't - can you show...

ok - this isn't a good question. I wrote DBCC CHECKDB and I got the answer wrong. I guess it could be down to BOL stating that disabled indexes aren't...

Ok - this has now been proven to be a bug inside MS, with a simple repro. Alex - let me know if you want to push for a hotfix...

Consensus (without proving it yet) is that this looks like a bug. Do you want to push for a hotfix if that turns out to be the case? If so...

How many entries are added to the temp table before the index rebuild? Are they added in index key order? Is there a noticeable difference in perf if the index...

Ok - I've started a thread with some folks from the Storage Engine, Query Processor, and Product Support. Will let you know what I find out.

Thanks!

ok - in that case if it only happens under load with concurrent executions of the SP, then I'd say it's definitely a bug. The index rebuild code is interacting...

Gail pinged me on this as I don't have alerts on this forum.

This looks like a SQL Server bug - the DBCC DBREINDEX creates a new set of allocations for...