how to find sortorder,char set,collation seq ?

• deepa123

  Mr or Mrs. 500

  Points: 545

  More actions

  October 16, 2002 at 12:34 am

  #58129

  Greetings All

  I have one sql server 7.0 installed . Since th installation was done by somebody else who has left the organization..

  Now we are using backup exec Veritas 8.6 to

  backup sql 7.0 on a seperate backup server.

  while trying to retsore the veritas backups on a freshly installed sql 7.0 server...

  i am starting with restore of master db ...

  veritas says" the new SQL server shoul be installed with same sortorder,char set,clooation sequence as that of original server whose backup veritas has taken.."

  Now i dont know all thses properties...

  How can i find these properties on an sql server?

  sort order,collation sequence,character set,unicode locale id,unicode comparison style

  Thanks in advance ..

  Deepa

• franco

  SSCommitted

  Points: 1642

  More actions

  October 16, 2002 at 2:35 am

  #438645

  In Query Analyzer run this:

  sp_configure 'show advanced options', 1

  GO

  RECONFIGURE with override

  GO

  sp_configure

  You will find all the informations you need.

  Remember to set 'show advanced options' to 0 again after you have done.

  HTH

  Regards

  Franco

  Franco

  
  Franco

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 16, 2002 at 3:56 am

  #438649

  Use sp_helpsort.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)