i have a temporary table called tbltemp which i use to update two tables
table1 in the existing database
table2 in another database

table2's database is a different collation and when i to do a

insert into db2.dbo.table2 select * from db1.dbo.tempdb, there is this collation error, would it be better to just change the collation ?
alter database2 collate latin1_AS_CI something. but it didn't work.

Is there another way to do this ?