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 |
|
jsmith
Starting Member
24 Posts |
 Posted - 2002-07-24 : 05:33:57
|
| I have been trying to copy an existing database onto a new server. Copying and attaching was fine, but the collation of the new database was not the same as the collation of tempdb and master on the server (Latin1_general_CI_AS versus Latin1_General_CI_AI).Ive tried changing the collation of the new datbase using alter database / collate etc, however encounter a locking problem.I then tried altering the collation of the master and tempdb databases, by using the rebuild registry option on the sql server installation cd, however this does not work (whatever option i select tempdb and master still come out as Latin1_General_CI_AI).I was thinking of a reinstall, but whoever has installed sql server previously has not done so properly, and the registry entries necessary to uninstall are missing. Does anyone have any suggestions? I was thinking of creating a second instance of SQL Server on the machine, then hoping that that would install the registry entries necessary for an uninstall. I also have rebuildm.exe running (to try to rebuild the master database with the correct collation), but as yet this has been running 24 hours.Any help would be greatly appreciated. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-07-24 : 06:10:59
|
| Rebuild the machine?It's integrity has to be in doubt after all this.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
jsmith
Starting Member
24 Posts |
Posted - 2002-07-25 : 06:05:32
|
| Think you are right nr - thanks for the advice. |
|
|
|
|
|
|
SQL Server Installation Problems