February 25, 2003 at 5:26 am
I upgraded my database from 7 to 2000 last week by restoring the dump taken from SQL7 database. The new installation has Finnish_Swedish_CI_AS as collation.
But the one I restored has SQL_SwedishStd_Pref_CP1_CI_AS.
In some stored procedure I create a temp table in TEMPDB and do join against some tables in this database. Then I naturally get an error 446."Cannot resolve collation conflict for equal to operation"
What is the best way to work around?
I personally think it is best to alter the collation of the database. But it seems to take a long time. My database is 400GB.
Any suggestion is very welcomed.
February 25, 2003 at 8:13 am
In this http://www.sqlservercentral.com/columnists/glarsen/collate_part1.asp I described how to work with different collating sequences.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply