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.

Back to SQL Server 2005

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-1) was last changed on 24-May-2017 15:30 by UnknownAuthor
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 1824

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1