Nice question.

I hesitated to supply the logical answer, suspecting a trick question on some bizarre unexpected SSIS behaiviour, but I decided to follow my instinct and I got it right....

Terry Mott (9/17/2010)

---

Supposed ProcA begins a transaction, then executes ProcB. ProcB begins a "nested" transaction and then performs a ROLLBACK before exiting. When ProcB exits, SQL Server raises...

I have to disagree with you,...

Thanks, Paul, for an excellent series! I rarely give the full five stars to an article (yes, I am criticall), but you have absolutely deserved them.

I don't think I'll ever...

rahul2671985 (9/15/2010)

---

Hi,

Thanks for replying me. I got stuck after "Having Exists".. the serch condition should take the groups which has max(a.thevalue) greater thaen 3. that I cannot figure out hw...

I second Nakul's suggestion to first read the entire discussion. If, after that, you still...

Actually, the...

Tom.Thomson (9/12/2010)

---

I think there's a small error in the explanation here. Round never returns a result of type decimal(8,6) because every decimal result that it returns has precision 38 -...

Yes.

The line

ALTER TABLE MyTable DROP CONSTRAINT PK_MyIdGO

should read

ALTER TABLE MyTable DROP CONSTRAINT PK_MyId

(That is, remove the GO at the end).

When I wrote that you...

mukeshkane (9/10/2010)

---

-- Create Table

CREATE TABLE MyTable (MyId INT IDENTITY (1,1),

...

Could you copy and paste the exact T-SQL code you are using? There must be something wrong there. I can run the code on...

Google...

bitbucket-25253 (9/9/2010)

---

Hmm seems like we have a disagreement on moving the Resource DB.

Now which reference is Correct can it be moved or not? ? ?

http://technet.microsoft.com/en-us/library/ms345408(SQL.90).aspx

From the above reference (Bold...

My sole critisicm of this article is that it's much too short.

I can't wait to read the parts three and four!

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 moved), here...