Well, "pleased" would be too mild a word. I am thrilled to report Paul that your method worked perfectly. Gail I also compared it to the export/import method, but that...

Paul, thanks very much for your reply - I'm going to experiment with the export/import method, as well as your method, in our labs tomorrow. I will certainly let you...

Thanks VERY MUCH Gail for responding, it would be great to have Paul chime in on this too.

If there's nothing else he can suggest, I'll probably go with your...

Also, the last backup without this issue is from over a month ago, so I can't simply restore and lose a months worth of data.

Here are the results of running:...

Thanks for replying. Here is the output. I will also re-run using REPAIR_ALLOW_DATA_LOSS and show you that output momentarily...

Msg 8976, Level 16, State 1, Line 1

Table error: Object ID 552389037,...