If you stare at the monitor really hard and squint, (A) actually is incorrect.

The BOL I have says the data type is dependent on the data type of the result set.  I "guessed" correctly on this question, but the question does not give...

How can you make such a claim?  sp_unsetapprole isn't even in BOL.

Someone really should screen these questions BETTER.  I'm looking 2005 BOL and it explicitly says the ONLY upgrade path supported from 2000 EE is to 2005 EE.

It's actually two (2) separate questions...each with a potentially different answer.

Truly a subjective question (based on the "correct" answer).  I feel cheated as well.

You folks are playing symantics here.  You need to read BOL.

Tried it...didn't work in my case

There is nothing inherantly wrong with running 2 instances of SQL Server on physical Server as long as you understand that they will be sharing server resources, and you divide...

I am getting the exact same error using ITW in Query Analyzer against a single select statement.  In playing with it, I have found it will not analyze a query...