Problem is sorted.

When you run sp_helpsort to check which Sort Order, Collation Order and Character Set is used on a specific server, you get an answer like "Unicode Locale ID=33280,...

Both servers are SQL 7.0.

I will check the NT service pack on the second server as It might be SP4 (the main server has SP6).

I have no idea how this Character Set got installed , it was done before my time in the company. The problem is that our main server is the one...