>>Have you verified what is the collation on the working server and on the non-working server?
>
>The collation on server 1 is Latin1_General_CI_AI.
>
>It is the same on the other server.
Ok, have you been able to determine what is different between these 2 servers? May be the OS on the servers?
If it's not broken, fix it until it is.
My Blog