• Using SQL SMSS 2008 I got 1,2,3,4 as well...

    I have run into similar problems using -- as a commenting method, though never in SMSS. Once my sql scripts are implemented (as is specific to my employer), they are executed in their entirety as a single line. This causes ALL code after the --'s to become disabled. When comments are necessary in my scripts, I use /* to make my comments */ and avoid this problem.