Thank you, Gail. I appreciate the additional information.

Fixing this particular system table in this particular case appears to have had no adverse affects in the test environment, so I...

Sorry - I forgot the crucial "AND t2.ID <> t1.ID". I've corrected my original post.

Hi terryphone,

If the data is reliably as you listed (the data is alphanumeric and the "like" IDs are always 6 numeric digits with or without a letter appended), you should...

Sorry - I probably asked my question in the wrong way.

What I really wanted to know was whether you would proceed differently (i.e., more cautiously) knowing the corruption affected a...

Hi Gail,

First off, thanks for the great article and thanks to the SSC folks for making it so easy to find.

I've just started a new DBA job at a company...

Another interesting tidbit from the story:

"Almost as puzzling as why she has set the lower bar for suing the world's biggest ad broker at a mere $100,000"

Perhaps the woman isn't...