SQL Server 2000<BR><BR>I need to change the collation for a database from case senstitive to case insensitive. <BR><BR><pre class="ip-ubbcode-code-pre">ALTER DATABASE ...

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 ...