sort order 51?

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  March 12, 2003 at 12:36 pm

  #58770

  I am installing sql server 7 and don't know which sort order is sort order id 51. I have an old sql 7 server that i am trying to restore to a new server. but the restore fails with the message "the backup sort order id is 51 but the server sort order id is 52". How can I find out which sort order is 51? Can I run a query on the old server to find out what sort order it has? Thanks in advance.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  March 12, 2003 at 12:52 pm

  #450902

  Sort order 51 is Dictionary order, case-sensitive, for use with 1252 character set.

  sp_helpsort