Changing the default Language

[simonk99]

Does anyone know how to change the language setting from english_US to British is SQL server 5.5? I have tried fiddling with osql and have had no luck. I really need to change it so that the date changes from mm/dd/yy to dd/mm/yy! I would be grateful for any information.

Cheers

Simon [sig][/sig]

 

[foxdev]

Simon, I'm completely ignorant of SQL v5.5, but isn't there a SET DATEFORMAT or similar command to do this? [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[elmo29]

Has anyone ever solved this?

 

[tlbroadbent]

You'll want to use sp_configure to change the default language.

USE master
sp_configure 'default language', 'British'
RECONFIGURE Terry

X-) &quot;Life would be easier if I had the source code.&quot; -Anonymous