Changing Date Formats SQL Server 2005
Each SQL Server has a default language. You can see what the default language is by executing these commands (in Query Analyzer).
sp_configure 'default language'
The default language is in the column config_value which is an integer that represents the language id.
If you run
You will see a list of languages that SQL Server supports.
This setting configures the default language for new users. By changing this setting, existing users will continue to have their original language. It is the login’s language setting that determines SQL Server’s date format.
Change the default language for each user by running the following command:
sp_defaultlanguage @loginame = 'Username', @language = 'British'
Logout and back in to the database for the change to take affect.
SQL Server 2005