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)?!

  • August 17, 2010 at 12:40 am

    #1207676

    mphilippopoulos (8/16/2010)

    Perry Whittle (8/16/2010)

    Correct, SQL Server setup inspects the server locale during install and selects a collation based on the regional settings. It is important to set these correctly during OS deployment!

    Unfortunately I'm paying for the mistakes made by the systems admin... Life's not fair...:angry:

    That's why I always insist that I carry out my own server builds. If I can't I check them rigorously them throw them back if they're wrong!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉