sql server misc: Default language - how to change (persistently) -- sql server misc

Default language - how to change (persistently)

Dan Freer
1/31/2005 5:55:55 PM

sql server misc:

I am going mad trying to get SQL Server to use the dmy dateformat as a
default (instead of mdy).

(I know about SET DATEFORMAY dmy, but this is not persistent)

To do this I have tried setting the default language to British English in
Enterprise Manager, but it make no difference.

If I execute the query: select @@language from Enterprise Manager is still
get 'us-english'

The reason I am trying to change the default is that I am trying to change
the column definition in the design mode of Enterprise Manager, for a table
which already has data in it form varchar() to datetime, and the data in
this column is in the form dmy...of course I get data conversion errors.

Any help much appreciated.

Kind regards
Dan

Re: Default language - how to change (persistently)

Scott Delaney
2/3/2005 10:55:52 PM

Have a look at sp_configure (to change the default language for new logins)
and sp_defaultlanguage to change it for existing logins. Then just make sure
you are connected as a user with the appropriate default set when you try
the change.

Hope this helps,
Scott

[quoted text, click to view]