jbuttery (8/31/2009)
I tried what you suggested and also tried running entire script. Couldn't get either to run. Could you post another script that will?
Sorry for the inconvenience. I find the web page’s default encoding (Unicode) actually adds some hidden characters to the script.
Now I’ve found the trick: First change the page encoding to be "Western European (Windows)", secondly copy and paste the code to a SSMS window, then change the strange character (it’s   on my screen) to white space. It works on my side now.
This is the first time for me to contribute script in this site, and I’ve not figured out how to change the encoding behavior here.
Good luck!
James