SQL Server 2005 install - Server Collation

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  August 8, 2014 at 10:20 am

  #291873

  I am attempting to install SQL Server 2005 with a specific collation SQL_Latin1_General_CP1_CI_AS

  Not getting it quite right.. what I am getting is Latin1_General_CI_AS

  Can someone help me with what choices I make on the COLLATION screen during installation to get SQL_Latin1_General_CP1_CI_AS???

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  August 8, 2014 at 12:16 pm

  #1736523

  I got it.

  SQL Collation, Dictionary Order, case-insensitive, for use with 1252 Character set