SQL Server 7 - How to Determine Collation sequence

• Chris Scott

  SSC Veteran

  Points: 297

  More actions

  May 20, 2004 at 1:00 am

  #87485

  Can anyone tell me how to determine the collation sequence of SQL Server 7.

  Using EM, my SQL Server 7 properties are

  Language English (United States)

  Code Page: CP1252

  When I use SQL Server 2000 I can use

  SELECT SERVERPROPERTY('collation')

  Is there an equivalent command for SQL Server 7?

   

  Thanks,

   

• sharrell

  SSC-Addicted

  Points: 477

  More actions

  May 21, 2004 at 4:08 pm

  #507363

  You should be able to run sp_helpsort.

  
  Regards,
  Steve

  Meddle not in the affairs of dragons, for you are crunchy and taste good with ketchup.