Unlike the previous version of SQL Server, SQL Server 2000 lets you specify collations for almost any task, at virtually every level within a database — from table column to SELECT statement.

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

Changing default collation SQL Server ... but I'm installing Microsoft Team Foundation Server 2005 on Windows Server 2003 R2.<BR><BR>This machine already has a SQL Server ... For example: <BR>Copy ...