July 19, 2002 at 12:22 pm
SQL 2k w2k server sp2
When I first installed the SQL server on my server, the default date
format was mm/dd/yy. Now I need to change that to dd/mm/yy in
regional settings, but its still not reflected in the DB's in SQL (its
still mm/dd/yy).
Is it possible to change it in SQL without a complete reinstallation
of the server?
July 19, 2002 at 5:43 pm
This is handled by the default language. Set the server and the users to British as that is the dateformat for British.
From BOL how to set server default
quote:
How to set the default language (Enterprise Manager)To set the default language
Expand a server group.
Right-click a server, and then click Properties.
Click the Server Settings tab.
In the Default language for user box, choose the language in which Microsoft® SQL Server™ should display system messages.
The default language is English.
And to set a preexisting user, use sp_defaultlanguage, or leave the server as is and set for only the users who need that format.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply