Got it right by process of elimination.

First, I thought the answer might be 1. A new Identity would not have been generated after the truncate so it...

Same here. As soon as it told me I was wrong,...

Good question. I almost missed it because I didn't notice it was loading a table variable at first. I was saved because I remember the previous question that...

da-zero (10/4/2010)

---

Good question and thanks to Oleg for the more detailed explanation.

@Nakul: no excuses about having no time to do the detailed reasoning 🙂 Post your question a few days...

Same here. I'm always looking for typos or some other trick.

Nice to see...

I guessed and got the question right just by using common sense without looking anything up in BOL.

The only complaint I have is that it should be worth...

p0peye (9/23/2010)

---

Please correct me if i am wrong...

My understanding is, you wont be able to commit or rollback inner transaction separately as the outer transaction will override with its commit/rollback...

No, because that will bring the database back to a previous state. The...

Toreador (9/22/2010)

---

I guessed wrongly that because it makes no sense to do a backup within a transactiobn, then the transaction would be ignored and it would work.

I'm not sure what...

I got it right but hesitated to click the submit button. It was too easy and I was looking for the tricky part of the question. I've been...

Hugo Kornelis (9/9/2010)

---

Good question. Too bad you did not include a reference in the explanation.

For those who want to double check (and to see HOW those system databases can be...

Nice question, I got it right.

I did want to point out that since the correct answer is that it will generate an error, no rows will be displayed...

Another trick question. You can do all 4 with SSIS's SQL Task but one is a sub-type of another. Reminds me of the recent issue with the Index...

Although I did get the answer right, I had to pick the closest response to the correct answer.

Technically, it was version 6.50.339 that fixed the Y2K issue. Then, Service...

ronmoses (8/3/2010)

---

Yep, I've been bitten by that one more than once. Until you learn that int/int "gotcha" it can be nearly impossible to troubleshoot a script that is experiencing...