i want to keep two databses with diffrent collation on one instence of sqlserver but following is the problem i am getting.
sqlserver is on Thai_CI_AS and one of the database is on Thai_CI_AS and other one is on SQL_Latin1_General_CP1_CI_AS
the one on SQL_Latin1_General_CP1_CI_AS is creating problem .
select * into #tempt from xyz
select * from #tempt t
join bridge b on t.name=b.name.
I found the tempdb is on Thai_CI_AS so this query was giving error
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Thai_CI_AS" in the equal to operation.
how can i resolve this problem.
is there any setting in master databse where i can tell that each database should use its own collation in tempdb rather than piking tempdb's collation.
2) can put something in connection string which can override the tempdb's collation
3) can put some setting in stored procedure which can override the tempdb's collation.