Posted by Erland Sommarskog on 10/09/61 11:43

Peter Nurse (PtrNrs@yahoo.com.au) writes:
>>Do you get this error with all databases, or only some?
>
> All databases including Northwind & Master neither of which I've
> touched.

Could you run this and post the output:

select name, collation_name, compatibility_level from sys.databases
select serverproperty('Collation')

Assuming that all databases are in mode 80, try running
"sp_dbcmptlevel Northwind, 90" and see if this changes anything.


--
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

• Next in forum: Re: Help selecting an alias
• Prev in forum: ANN: Database Workbench 2.8.5 released
• Thread view: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties

[Reply to this message]