How do I change the code page in SQL Server 7.0 once it has been installed?
The code page is selected with sort order upon install. Though you can have clients with a different code page from the one the server installed, that brings code page translation into the process. The same issue applies to the server having a different code page installed than the OS, which also requires code page translation.
The short answer is that you cannot change it; you have to re-install it.