could the commands have been left in the middle of a stored procedure somewhere, probably put in during dev / testing?

I have seen this before but the command was granting...

thanks for the link but still getting the SQLSAC error which i believe is the root of all my issues...

anyone???

getting pretty desperate now :crazy:

create index with drop_existing does not work either but fully dropping the clustered index then re-creating it does.....:w00t:

bit strange that an index rebuild doesn't work but a drop and create...

hmmm, i've tried rebuilding the clustered index on this table (i did this on thursday when we had the issue) and it says its successful but still erroring when i...

well i've tried the restore of the full backup plus tlogs up to 5am when we had the first error regarding this corruption and it has restored the corruption. I...

I think it's a good idea to get this blogged and make ppl more aware of this issue, especially if it could potentially catch u with it pants down!

If u...

I'm convinced this is the problem. I was confused yesterday when one of the errors referred to the unique clustered index beingcorrupt but that table did not have a unique...

could this be a potential issue?

http://support.microsoft.com/kb/954734/

GilaMonster (11/13/2008)

---

Swirl80 (11/13/2008)

---

the problem with restoring a backup on this particular database is that it is involved in almost every part of our systems and links in one way or...

Unfortuantely not, we're on sql server 2005 enterprise (v9.0.3239) which is why i'm baffled as to why we're getting errors which are / were specific to 2000 and supposedly fixed.....

I've...

the problem with restoring a backup on this particular database is that it is involved in almost every part of our systems and links in one way or another to...

anyone???

Good script if you only have one database in your system, what if you didn't know what database it existed on???

A loop through all none system sys.databases would be an...

Thanks for that, i think i'll look to create a job to tidy it up overnight. Its a shame it doesn't "keep it in sync" using transactional replication - i...

Thanks for that. Unfortunately i cannot afford any latency (well, as little as possible!) so sync with backup on the publication DB is not an option.

Since the replicated DB...