Posted on 2006-04-25
Looking for solutions to a problem I noticed that the server collation on box1 is SQL_Latin1_General_Cp1_CS_AS and on another it is Latin1_General_CS_AS. Looking deeper at our dev and production servers it seems that we have this mix in more places.
Is this a problem?
We are about to migrate some DBs to 2 new boxes and obviously want to get this right before doing so.
Looking back at 2 servers that have been operating as norm for ages and they are both SQL_Latin1_General_Cp1_CS_AS.
I don't even see Latin1_General_CS_AS listed in BOL.