Posted by Peter Nurse on 10/01/44 11:43

>Could you run this and post the output:

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

name collation_name
compatibility_level
----------------------------------------------------------------------------------------------------------
master Latin1_General_CI_AS
80
tempdb Latin1_General_CI_AS
90
model Latin1_General_CI_AS
90
msdb
SQL_Latin1_General_CP1_CI_AS 90
pubs Latin1_General_CI_AS
80
Northwind Latin1_General_CI_AS
90
ASPProBU SQL_Latin1_General_CP1_CI_AS
80
ASPProWeb SQL_Latin1_General_CP1_CI_AS
80
ASPPro Latin1_General_CI_AS
80

(9 row(s) affected)


----------------------------------------------------------------------------------------------------------
Latin1_General_CI_AS

(1 row(s) affected)



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

Doesn't seem to fix anything.

• Next in forum: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties
• Prev in forum: Re: Order by in a INSERT INTO..SELECT
• Thread view: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties

[Reply to this message]