When you select a collation for your server, database, column, or expression, you're assigning certain characteristics to your data. These characteristics affect the results of many operations in the ...

Setting the server collation in SQL Server The server collation is specified during [!INCLUDE ssNoVersion] installation. The default server-level collation is based upon the locale of the operating ...

The character set Latin 1 (or ANSI), for example, which is referred to as ISO 8859-1 under SQL Server 7.0, is called ISO 1252 in SQL Server 2000’s default settings.

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.<BR><BR>This machine already has a SQL Server 2005 ...