I have a SQL database (named "AccCRM") loaded on one SQL
Server v7. This SQL Server has been installed with a
specific sort order.
I need to transfer AccCRM to another SQL Server v7 which
was installed with a different sort order (and has its own
SQL database (named "DTE").
I've been unable to do this: I cannot run a restore onto
this second SQL Server. I've been unable to do a
successful import onto this second SQL Server. There
doesn't seem to be a way around this except for
reinstalling the SQL Server in the same sort order AccCRM
was installed under. But that will affect my DTE
So, my question is three-fold:
1) Is there a way around this w/out reinstalling the SQL
2) Is there a way to change the sort order value of my
second SQL Server so I can restore my AccCRM database onto
it that does not affect my DTE database?
3) Finally, can I install another instance of SQL Server
on this same box (different path, same server) with the
correct sort order configurations but not affect my DTE
Any help would be greatly appreciated. Thanks.