Category: ASP

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

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.

SQL Server 2005

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.