Is it possible to have instance of SQL SERVER database with Case sensitive From case-insensitive SQL SERVER

• madgulakrishna

  SSC Enthusiast

  Points: 112

  More actions

  April 1, 2005 at 1:58 am

  #110531

  I have SQL SERVER installed. By default it is case-insensitive.

  Can I have an Instance of SQL SERVER with Case Sensitive. Is this Possible??

  Thanks in advance.

  Regards,

  Krishna

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 1, 2005 at 5:29 am

  #550046

  Possible, install an instance with specified Sort Order.

  Collation settings in Setup of BOL describes the detail.

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  April 1, 2005 at 5:49 am

  #550053

  Taking it one step further you can even have COLUMNAR collations in the SAME table be different from each other AND the database

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net