OK, here is a quick update, I have managed to get this configured as per my requirements.

The locale has nothing to do with the collation settings that we need.

In order...

Let me state what I am doing:-

Fresh install of SQL server 2000

Selecting custom installation

Selecting:-

Lattin1_General

Acent Sensitive

I cannot set the collation with the other option as AS is not available

Once the...

I am having the same issue.

The locale of my machine is United Kingdom. I think it is something to do with the locale not being United States.

I thinkCP1 specifies Code...