Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
 Posted - 2001-11-16 : 18:19:29
|
| My computer was recently flattened and rebuilt, running Windows XP Pro and SQL Server 7.0 Desktop Edition. Apparently when SQL Server was installed, the person selected Sort Order ID 32: U.S. English. When I try to restore a copy of a database from our QA server, I get the error that the database has a different Sort Order ID (52 - ISO Character Set) and it aborts the restore.Upon researching BOL and these forums, I get mixed information. Under "Default Sort Order ID Option" BOL says "Note: Use SQL Server Setup to change sort orders. Do not use SQL Server Enterprise Manager or the sp_configure system stored procedure." But, under "Changing the Character Set, Sort Order, or Unicode Collation", BOL says "In order to change one or more of these settings, you must rebuild the master and user databases."Now my questions: Have any of you actually run the rebuildm.exe utility? Were there any concerns? Since I have no data I need to retain on this machine, would it be better to do a fresh install? It appears that either way I need the original SQL CD's from which it was installed to fix my problem.Thanks, in advance!-------------------It's a SQL thing... |
|
|
|
|
|
Rebuildm or Setup