Agree. The SQL 2005 instances that we have are all running SP4 (because we need to certify our products against the latest & greatest). The SQL 2008 are also either SQL 2008 SP2 or R2 editions. In all editions, the answer is as Hardik indicated - 1,2,3,4.

I do believe that the question could have been more specific about using SQL 2005 RTM, and not the latest & greatest.

In any case, I learnt something new today (that when constructing SQL statements, one needs to be very specific and precise while working with CR/LF.