How to change Unicode comparison style

• regina regio

  Grasshopper

  Points: 20

  More actions

  August 25, 2007 at 10:22 pm

  #118371

  Hello,

  I am trying to restore a database on SQL 7.0 using the datafiles from another database. I detached the source and target database then copied the datafiles on operating system level. The source has been reattached without any problems. However, the target database cannot be attached and I'm getting the following error: 

  Server: Msg 1816, State 16

  Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server.

   

  I executed db_helpsort on both databases and found that the source database is set to case-insensitive, kana-insensitive, width-insensitive while the target is case sensitive. I need your help in altering the target to have the same settings as in the source to proceed with the attach. I'm not really sure how this can be done in MSSQL 7. I was wondering if I can just reapply the Service Pack and choose the required options this time? I am not really a database administrator and does not have extensive knowledge for backup and restore.

   

  Thanks,

  Regina

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739117

  More actions

  December 2, 2007 at 4:15 pm

  #756326

  In SQL 7, I believe the only way to do this is with an uninstall, reinstall of the server.