I just want to confirm the following. We have SQL server 2000 with Binary sort order and 15 databases. In order to change the sort order not just on the server, but on all the databases (ie so that each application accessing the data will recognize the sort order on the data), we need to:
1. Install SQL Server 2000 DOCI and create all dbs.
2. BCP out each database, then BCP all data back into each db (do have an excellent document on how to do this).
Some people have said that you can simply either rebuild the master db with binary, or simply copy-paste the mdf/ldf's into a DOCI install, but that will not rebuild the user databases. The data within each database is actually stored in binary and not DOCI correct?
1. Install SQL Server 2000 DOCI and create all dbs.
2. BCP out each database, then BCP all data back into each db (do have an excellent document on how to do this).
Some people have said that you can simply either rebuild the master db with binary, or simply copy-paste the mdf/ldf's into a DOCI install, but that will not rebuild the user databases. The data within each database is actually stored in binary and not DOCI correct?