September 21, 2006 at 11:29 pm
I am trying to setup a MSSQL2000 instance with the collation SQL_Latin1_General_CP1_CI_AS as the default collation however I cannot select this collation anywhere in the installation (that I can see). I have read that this is a fairly common problem. Does anyone know how to fix this?
The ERP database on my current SQL2000 server in production is using SQL_Latin1_General_CP1_CI_AS as the default collation so I know it can be done. I have to move the current ERP database to a new server hence the requirement. I believe that the server and database collations need to be the same.
Can anyone help please?
September 25, 2006 at 11:04 am
When you are installing, select the lower radiobutton "SQL Collations" and the collation named "Dictionary order, case insensitive, for use with 1252 Character Set" On my servers with US English OS this collation comes up as default.
Regards,Yelena Varsha
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply