Hugo Kornelis (12/10/2010)
Except it doesn't.If you copy/paste the above in an SSMS query window and hit execute, you get "Command(s) completed successfully."
Exactly. I try to answer the questions without executing the code so I thought the missing space would cause an error.
Remember, there are so many trick QOTD's so I'm always looking for the trick. I thought I found the trick and it was that a space was missing. The lack of the space actually had nothing to do with the error but I thought it did so I selected the error message I thought would have been generated and got it right but for the wrong reason.