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. <BR><BR>DataBaseA is ...

SQL Server 2000I need to change the collation for a database from case senstitive to case insensitive. ALTER DATABASE COLLATE SQL_Latin1_General_CI_AS When I try to so, I get a whole slew of ...