Posted by Erland Sommarskog on 10/03/84 11:43

Peter Nurse (PtrNrs@yahoo.com.au) writes:
> I have just upgraded to SQL Server 2005 from SQL Server 2000.
>
> In Microsoft SQL Server Management Studio, when I click on database
> properties, I receive the following error:-
>
> Cannot resolve the collation conflict between
> "Latin1_General_CI_AS"
> and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
> (Microsoft SQL Server, Error: 468)
>
> Some reference suggest that I can change the database collation by
> clicking database properties!
>
> What can I do?

That smells like a bug. But question is: how did you arrive here?

If I understand it right, you had an SQL 2000 instance that you upgraded to
SQL 2005?

What server collation did you have in SQL 2000? Did you select a different
collation when you upgraded?

Do you get this error with all databases, or only some?

What you could try is install the CTP of SP1, to see if the problem
is resolved, although my gut feeling says that it is not. You find the
CTP here:
http://www.microsoft.com/downloads/info.aspx?na=22&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d39ebef74-1c29-49fe-8221-c94f2b52f6c6%26DisplayLang%3den


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]