Posted on 2004-10-26
I have a just totally rebuilt a SQL Server 2000 server and, due to a bit of an oversight, used 'sp_attach' to chop in the database.
I'm getting an error when running a specific SP
"Cannot resolve collation conflict for equal to operation."
This SP uses tempdb and as I understand it from Googling, my problem is caused by a conflict between the tempdb and the SP fields 'collation' (this is all totally new to me)
All the 'standard' databases on my new Server, including tempdb, are LATIN1_General_CI_CA
My database application with the conflicting sp, is SQL_LATIN1_General_CP1_CI_CA
My question is, what is the best way to resolve this.
It's been suggested that perhaps I create a backup, create a new blank database and import the backup.
Thoughts on this, or perhaps an easier solution that doesn't require any 'downtime'.