Get SQL Server Case Sencetive

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  November 19, 2003 at 11:45 pm

  #83203

  Is there any way to know whether the sql server is set to case sensetive or not

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  November 20, 2003 at 7:02 am

  #482848

  sp_helpsort 

  or

   select (value & 0x1) from master.dbo.syscurconfigs where config = 1125 

  will return 1 if 'case insensitive'

  Far away is close at hand in the images of elsewhere.
  Anon.