Case sensitive database instance

• Dean Jones-454305

  SSCarpal Tunnel

  Points: 4804

  More actions

  May 6, 2009 at 8:51 am

  #100624

  Hi All,

  Just noticed on an instance of a customer database, I have noticed that objects (databases and table objects all seem to be Case sensitive). Select * from Sysobjects would fail, whereas Select * from sysobjects works fine.

  Is there any reason for this, the same applies to database names as well.

  Cheers

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  May 7, 2009 at 7:00 am

  #990310

  Sounds like the server has been installed with a case-sensitive collation.

  Run SELECT SERVERPROPERTY('Collation') to check.

  [font="Verdana"]Markus Bohse[/font]