I want to do a silent install of sql express 2008 (free edition)
In my configuration file, how can I set the default language to British English and date format to "dd/MM/yyyy".
Thanks for your help
Why u need it ? You simply need to Qery and Build it. . Language doesnt really mtters here.
Data formats are Fully Qualified in Default.
A possible solution to this is to use the ISO Standard format for sending the datetime data to SQL Server, which is "YYYYMMDD" (no separators). Using the ISO format is more "international," and is independent of the default language. For more information, see the CONVERT function in the SQL Server Books Online.
first Choose the Language
select * from sys.syslanguages
Now Copy and PAste the Whole Query without touching a single statement
I have configured it for
British English and DD_MM_YY Format.