ft55 (1/19/2015)
Looking on an explanation on the following if possible.At an O/S level Windows Server 2008 R2 is configured with Region and Language as English (United Kingdom)
At a server Collation level the following is configured : LATIN1_GENERAL_CI_AS
Default Language under Server Properties > Advanced is English
However Server Properties > General reports English (United States)
Is this a default that cant be changed ? I havent selected English (United States) at any part of the install process ?
Many thanks in advance
Frant101
According to http://msdn.microsoft.com/en-us/library/ms179254(v=sql.105).aspx, the only way to change the default collation of a server is during install. You can specify a default collation for your database that is separate from the server default collation when you create the database.
As a side note, the CI_AS part of the collation means Case Insensitive and Accent Sensitive when doing character comparisons. I'm not sure if that would make a difference for UK English, but you should have an idea of what kind of text is in your database and whether you need accent sensitivity or not for your database.