cancel
Showing results for 
Search instead for 
Did you mean: 

Collation change in MS SQL SERVER 2000

Former Member
0 Kudos

As i have installed sqlserver 2000 with default collation SQL_Latin1_general_CP1_CI_AS, Now i am unable to continue ECC5.0 IDES Installation which requires the collation SQL_Latin_General_c850_BIN2. Please let me know how to change default collation to BIN2 in sqlserver 2000. I have seen note 600027 which seems to be not clear.

thanks

balan

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Chidam,

you have to distinguish between the server collation and the database collation. In your case, as far as I can tell, you have to uninstall SQL Server 2000 and install it again with the right collation (Binary order for use with the 850 Multilingual Character Set).

Please also refer to note 505906 which describes your scenario.

Regards,

Sven

former_member433984
Active Contributor
0 Kudos

Hello Balan,

why it is not clear?

Did you try to download InstColl.exe and run it?

What was the result?

The note describes exactly the solution you need.

best regards.

Former Member
0 Kudos

Hi, Using instcoll.exe now converted to BIN2.

Thanks verymuch