me too, although i know the logic behind truncate 😀

Good question, learnt something new, thanks.

good stuf..Tushar..keep up the good work 🙂

Simple rules:

1) Never create any objects in system databases(specially in master)

2) Dont try to recover master from one instance/server to another...script logins from source and run the script on target

Hope...

Oh!!! so this happens? I never seen it hence the question was. I will do some RND on this.

How can both the DBs (Principle and Mirrored) be at "restoring" state at same time? Has anyone came across this situation due to mirroring issue???

Why dont you use Maintenance Plans?

Good question..never thought of using count(*) for 2 tables in one T-SQL...thanks for question

trickey question...already existing Clustered Index just went off from my mind and I answered TRUE...I was wondering why Paul would have asked such a simple question and w/o giving it...

and last one from me:

1 5 + 3 + 1 + 1 + 1 = 21

and one more:

1 5 + 1 + 1 + 1 + 3 = 21..

I guess there can be many more answers..but not write it here..anothers can try it out 🙂

One more:

1 3 + 1 + 1 + 1 + 5 = 21

And another answer is:

1 3 + 3 + 3 + 1 + 1 = 21

Here is the answer:

1 1 + 3 + 3 + 3 + 1 = 21

R u sure your puzzel has mathematically valid answer? 😉