How can I set Monday as the first day of the week

[jabedin]

Hi There,

Our SQL server is set to UK which leads to start the week on Sunday. How can we cange the database setting to Monday as the first day of the week. If we change this in Query Analyzer using SET DATEFIRST, this works only for the session.

Any help regarding this will be highly appreciate

 

[Otto]

AFAIK, the only way to change it globally to change the language setting, because the datefirst is related to it.
Use the sp_helplanguage to show the default settings for each language.
And use the sp_configure or sp_defaultlanguage (for an existing login) to change it.

 

[mrdenny]

What language is the login set for?

Try changing the language of the login to british english.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jabedin]

Thanks OTTO/mrdenny. I will do the way been suggested.

Regards
Jay