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 |
|
Ernie
Starting Member
2 Posts |
 Posted - 2003-05-19 : 21:07:40
|
| I made a backup of the databases and copied them to a client machine, then took the server off line and copied to the new server, named the same as the old, with the same ip address. I get an error of improper sort order. This was late in the day so I haven't looked at the settings yet, but thought someone may have run into this before. ThanksErnieErnie |
|
|
DavidD
Yak Posting Veteran
73 Posts |
Posted - 2003-05-19 : 23:49:45
|
| Check the locales for your 2 servers (Control Panel -> Regional Settings). These are what determine your default collations for your SQL installation. Also compare the collations of the two databases. (information_schema.columns is one way) |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-20 : 01:20:05
|
| You could also run sp_helpsort on the source server to determine the proper sort order.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
Ernie
Starting Member
2 Posts |
Posted - 2003-05-20 : 14:27:28
|
| That's exactly what I needed. Regional settings were fine but I had picked a different sort order than the default. Thanks for your help.Ernie |
|
|
|
|
|
|
Improper sort order when restoring to new server