Collation question

• Tmp

  SSCommitted

  Points: 1938

  More actions

  April 29, 2003 at 6:44 am

  #160099

  I have to replicate a SQL 2k Installation, and the old server collation shows :

  SQL_Latin1_General_CP1_CS_AS

  Any knows what means this? How can i look the collation information in a fashionable way?

  Thanks 🙂

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 29, 2003 at 6:57 am

  #455668

  This means that your sql server is Case Sensitive, Accent Sensitve.

  More details available at following msdn site

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_5ell.asp

• Tmp

  SSCommitted

  Points: 1938

  More actions

  April 29, 2003 at 8:14 am

  #455687

  Thanks for your response.

  Regards