tgarland (5/11/2011)
Is there any possibility with having different collations across the databases that you could run into issues when running queries that cross databases especially involving joins? What about any issues with TempDB if the collations are different? Thanks.
I ran into this recently when I created a table with database defaults to test something, joined with an existing table, and had collation issues. Very annoying, but it's something that we have documented and have to deal with.