Anyone know how to set this up as the default collation? I tried several options, including SQL Collations: Dictionary Order, Case Insensitive, for use with 1252 Character Set, and Collation designator and sort order: Latin1_General, Accent Sensitive. Neither of these gave me SQL_Latin1_General_CP1_CI_AS, they were Latin1 (without the preceding SQL). While they are similar, they are not the same, and we were having conflicts with 3rd-party programs that need this specific collation set. It would be nice if there would be an initial way to install it with this setting, without having to rebuild the master database.
Not sure how much of this is relevant, but the server is running Microsoft Windows Server 2003 R2, 64-bit machine. It originally had SQL Server 2005 Express installed. We uninstalled this, and installed SQL Server 2005 Standard Edition 64x, then upgraded it to SP3.
asked Jun 18 '10 at 10:47 AM in Default
To change the server collation, which will be the default collation for all databases created on it unless specified otherwise, you will need to rebuild the master database, as you have probably already read
Update: following on from jatkin's comment
BOL states that English (United States) locale corresponds to