sql server - Database Collation and Server Collation Different
Posted on 2009-07-02
I have just restored a copy of a database created by a third party company on a second server so I can test it.
When I ran into the inevitable problems, the 3rd party support guy looked at it and said that I should expect problems because the database collation (SQL_Latin1_General_CP1_CI_AS) was different from the server collation (Latin1_General_CI_AS). He said that if I reconciled the server collation to the database collation (not the reverse) it would be just fine.
I am familiar with the concept of collation but have the following questions:
1. How to change the server collation to SQL_Latin1_General_CP1_CI_AS ?
2. Why might it matter that the two are different?
I don't want to change anything if I don't have to as rumour has it that the process is rather messy.