So because the SQL native client sets it to 2gb, the question is ambigous in my opinion. I was expecting to see a 2gb answer. Whoever does a...

Thanks much Roy. It was very instructional..

as mentioned in a prior comment, the answer to the question is wrong!!

Try runing this and you'll see a 2/1/09 value....

create table #a (InsertedOn datetime)

insert into #a values ('20090131');

insert into...