EXACTLY! - From the page you quoted

http://msdn.microsoft.com/en-us/library/bb934049.aspx

So you typed in the wrong answer for the...

If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist as stated in this...

I agree.:-D:-D

I am one who selected a wrong answer because I did not remember the following found at what I think may be a better link for this question

'If the...

I did not know about the 1752, though I should have. :hehe: I totally expected it to work after going over the BOL entry on datetime2. It is...

I did not mean to imply that BOL told me what the error would be, and since I was writing this quickly, after testing and breaking up the queries into...

The problem is that when you run the code as is, you will not get to Proc3; If you do, you get the answer that you are looking for....

This is a statement I use all the time in creating Dynamic SQL strings. It is great for use with pivot tables. Something I have been using for...

I was sure I knew the answer to this, but I do believe I am too influenced by Developing T-SQL and PL/SQL at the same time. This information is...

I totally agree that the answer is incorrect and grouping_id is not a sub-clause, the group by subclauses listed at the following link http://technet.microsoft.com/en-us/library/ms177673.aspx did not list Grouping_ID as...

I went to the link posted as an explanation http://msdn.microsoft.com/en-us/library/bb510427.aspx

and the example listed at the top of the page is exactly the same as the question, and it says they...

I must say that even though I was able to select the correct answer I was truly drawn to selecting nepotism as my answer, which I saw that one brave...

The Declare @myDate as Datetime is an invalid statement and will cause an error. The as is used to assign an alias in T-SQL and the declare verb does...

I created the table and used the selection from the question and all that was returned was the message stating that the query was complete. I fully expected that...

There is always DTS, and with multiple methods of sending an e-mail through DTS, I do not see why I cannot attach all four reports to a single e-mail. ...