SQL Server 2000 ... change collation, and then add them all again. But that will take a lot of time since I need to script out all the constraints first by going to each table mentioned in the ...

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

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

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation.