That means, you can have a default SQL Server installation with case insensitive collation, but a specific database or a set of columns can have case sensitive collation. <HR></BLOCKQUOTE> ...

I am trying to write a select statement that joins two tables from different databases on my SQL server. The issue is that the two databases are different collation types. DataBaseA is collation ...