So let me get a little more specific here is my code:
set A.f1= B.f1
from db1..table1 A
join db2..table2 B
on A.My_field= B.My_field
The offending field is B.My_field which appears to be causing the collation error (failed with the following error: "Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.)
How do I change the collation on the fly -- please post code?