Home Forums SQL Server 2008 SQL Server 2008 Administration Default Server Collation for SQL - does it depend on the O/S version (standard vs. enterprise)?! RE: Default Server Collation for SQL - does it depend on the O/S version (standard vs. enterprise)?!

  • I found the culprit!

    The Windows locale is different in Server2 from that everywhere else in my environment.

    On Server2 it is English/Canada.

    On the rest of my env it is English/US.

    This affects the default SQL collation setting according to this link: http://msdn.microsoft.com/en-us/library/ms143508.aspx.

    For English/Canada the default collation setting is Latin1_General_CI_AS.

    For English/US the default collation setting is SQL_Latin1_General_CP1_CI_AS

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]