I agree, there is no way 01/30/2009 will be returned. After answering incorrectly, I remembered having the same thing happen to me a couple of years ago.

Roy

If the explanation is correct, the answer is incorrect.

Roy

It appears there are two correct answers in today's Question of the Day. The link that is referenced in cludes the following:

Every time that a row with a timestamp column...

I disagree with the posted answer. If I have MSDE and decided to buy SS 2005 EE I can certainly upgrade the MSDE data to SQL Server 2005 Enterprise Edition....

Maybe I am off on the terminology but, from BOL SQL Server 2005 EE

(see below) but I do not agree that snapshots cannot be backedup.

Roy

"Microsoft SQL Server 2005 supports...

According to BOL "C" is the correct answer.

From BOL about @@textsize:

Returns the current value of the TEXTSIZE option of the SET statement. This specifies the maximum length, in bytes, of...

I, too, tested the t-sql statement and I find that D is the correct answer.

If "D" is what is returned how could it be the wrong answer?

Roy

You all make sense and I was wrong again!

Thanks for the comments and explanations.

Roy

I disagree with the answer for this question. Check policy is on by default so check policy does not have to be included when check_expiration is set to on.

I have...