EXEC GO should work exactly as it does.

Let me try to explain from my point a view. Lets break down what we are asking SQL to do:

First...

I believe there is more than one correct answer to this question... I think this depend on your perception of Impersonation.

I to tested the code in QA against SQL 2005 instance and got the following:

Server: Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'GO'.

Therefore, I choose incorrectly?

I think...

I got this wrong as well... I selected FAST-FORWARD... It you use STATIC this can cause temp tables to be created in tempdb, which can lock out other...

I agree, this was an excellent question!

I have used "select * from sys.columns where sys.columns.is_identity = 1" before and it works for me. Therefore it is eaiser. I guess it depends on how...

If you have to add something to the command then it can not be a default. Count me in with the dissenters. Now give me my point! 🙂