I'm sorry, but I guess we're sorta talking past each other in this thread, although it has been very educational for me.

Even if "GO" isn't part of T-SQL, etc., I just thought it strange/silly that QA wants to process it especially since the editor itself recognizes it as a comment (i.e., it was green, which is what threw me off initially). I mean, I can't think of any other situation where something in a comment is handled (rather than ignored). I mean, why can't QA just go "oh, everything from /* to */ is a comment, so I will go on and look for "go"s someplace else..."

No biggie; just a thought. 8-)

John BArone


>GO isn't a part of T-SQL. It's QA command that indicates the end of the batch and tells QA to process it.
>
>>Yes, that is what I got.
>>
>>What my point is (was?) this: that if something is in a comment then it should be ignored, whether I type "go" or "SELECT x..." or "Micky Mouse is my favorite character!" After all, commenting out lines of code is something that every programming language allows you to do, and I really still do think it's strange behavior that the parser tries to interpret what's between /* and */ instead of ignoring it...
>>
>>John Barone
>>
>>
>>>It is a bug, because it is fixed in the service pack (SP)
>>>if u run it after installing the SP then it will not run
>>>and will give u the following error .
>>>
>>>Server: Msg 113, Level 15, State 1, Line 10
>>>Missing end comment mark '*/'.
>>>Server: Msg 170, Level 15, State 1, Line 2
>>>Line 2: Incorrect syntax near '*'.
>>>
>>>As a result , u should remove the 'go' from the comment.