sql server - Database Collation and Server Collation Different

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.


Hopeful Kiwi
Who is Participating?
kiwi_731Connect With a Mentor Author Commented:
Hi Ritesh

The IT people have finally come back. I posted them the link http://msdn.microsoft.com/en-us/library/ms179254(SQL.90).aspx from one of the comments under the thread that you mentioned , and they managed OK. They created a separate server instance with the corrected collation as there was already another database on the physical server which they didn't want to disturb.

Thanks for your help.

Hopeful Kiwi
RiteshShahConnect With a Mentor Commented:
if you want to change collation of sql server itself, follow the below link


if you want to change collation of only one database than

alter database dbname collate SQL_LATIN_GENERAL1_CI_AS
kiwi_731Author Commented:
Hi Ritesh

Sorry about the long delay, due to the fact that I am dependent on other people to put the changes through for me.

I will assign points as soon as I know how they have got on.

Hopeful Kiwi
glad to know that you are now free from this problem.

Ritesh Shah

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.