Non of any answer is correct. But still I select -1, -0, 1 and it is showing incorrect answer.

Jeff,

LOL 😀

DateFirst doesn't affect DateName value but in case if it does to anyother Date function 🙂

Actually in lots of Stored Procedure we have used SET DATEFIRST option and then DATENAME function so before migrating our server from 2000 to 2005 we just wanted to confirm...

Thanks Peter,

I was doing the same thing but I was thinking if I did something or I may be lacking somewhere.

Thanks.

Sorry Peter, my mistake. I edited the last insert statement. Please try to execute the same and then you get to know what's the prob.

Anyway...thanks 🙂

Probably the reason is, you are using update statement using a different object owner while the object has been created using other one.

For example, if an object has been created...