checking sortorder,character set,collation seq.

• deepa123

  Mr or Mrs. 500

  Points: 545

  More actions

  October 16, 2002 at 12:25 am

  #105693

  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,clooation sequence,character set..

  Thanks in advance ..

  Deepa

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 16, 2002 at 3:58 am

  #438650

  Please do not cross post. Duplicate thread please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7459&FORUM_ID=5&CAT_ID=1&Topic_Title=how+to+find+sortorder%2Cchar+set%2Ccollation+seq+%3F&Forum_Title=Administration

  Moderator please lock or remove thread.

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