January 21, 2002 at 2:21 pm
I inherited several applications with 6.5 sql server databases. They all need to be moved. I have to find out what the code page/sort order on the current ones are so I can load slq 6.5 on new machines and port the databases over.
Thanks,
Joseph Devereaux
January 21, 2002 at 4:24 pm
I think this is fixed for v6.5 servers and not changeable by db.
I know SQL Setup will show this.
Steve Jones
January 22, 2002 at 5:56 am
I know that these two parameters (code page and sort order) are only set at the time of the sql server 6.5 software install.
I have to install sql 6.5 on 3 new machines. I need to find out from the existing sql server software what code page and sort order they are currently running so I can install the software correctly on the new machines.
thanks,
Joseph Devereaux
January 22, 2002 at 9:32 am
Try running setup on the original SQL Server. It has options for rebuilding master, reinstalling, change network support, and code page. You should get the existing setttings from there.
Steve Jones
March 4, 2002 at 7:59 am
You can also get the exisiting code and sort order from the error log. During SQL Server start up the following information can be found in the error log:
for example,
2002/02/19 spid1SQL Server's default sort order is:
2002/02/19 spid1'bin_cp850'(ID=40)
2002/02/19 spid1on top of default character set:
2002/02/19 spid1'cp850' (ID=2)
Also the stored procedure sp_configure can provide this information.
sp_configure 'default sortorder id'
for example it would return this information:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
default sortorder id 0 255 40 40
where 40 is the ID.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply