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'

If you run

sp_helplanguage

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.

Back to SQL Server 2005