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.