Hi Scott,

(I have corrected my first posting here:) yes you are right with your code, because DATENAME expects a date. But in the other cases where dateadd is used the...

SwePeso's solution works for me. It is independent from language and @@datefirst.

Good Point Peter!:-P

Hi MobashA.

nice script, but not enough information.

I've posted a script on a german website for sqlserver 2005, which you could use to show all users, grants and roles in a...