Yup that's it. When I copied and pasted into SSMS there seems to be no problem, but when I pasted the script into NotePad++ it all showed up. Once I removed the characters the sp executed properly.

Now the for the final question. When I execute the script with the FixALL option I get the following error message.

Msg 259, Level 16, State 1, Line 1

Ad hoc updates to system catalogs are not allowed.

Have you seen this before and if so how did you correct it.

Thanks again for helping me out. This is an EXCELLENT script and should be in the Best of SQL Central.

Rudy