Collation inconsistancies

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Collation inconsistancies

Collation inconsistancies

Rate Topic

Display Mode

Topic Options

Author

Message

njw

Posted Wednesday, May 07, 2008 5:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 24, 2009 10:13 AM
Points: 1, Visits: 15

hi folks

I’ve had a SQL 2000 server restored (using Veritas 9.1) to another server also running SQL 2000. I now have a collation problem.

When trying to add users to a database, I receive a "Error 446: Cannot resolve collation conflict for equal to operation" message.

I noted that tempdb and user tables collation don’t match - so I was going to change the user tables. However, the master collation doesnt match tempdb, model or msdb.

Server is set to SQL_Latin1_General_CP1_CI_AS
Master - SQL_Latin1_General_CP1_CI_AS
tempdb, model, msdb - Latin1_General_CI_AS

I was under the impression that when tempdb was recreated it inherited the master database's collation? This doesn’t seem to be happening.

any ideas?

much appreciated

N.

Post #496210

« Prev Topic | Next Topic »

Permissions