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

I haven't been much of a technical guy for a while but I'm installing Microsoft Team Foundation Server 2005 on Windows Server 2003 R2.This machine ... Changing default collation SQL Server 05 ...