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.

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 already has a SQL Server 2005 installation, and ...

If necessary, numbers are applied to the end of the name to make it unique. See The DQUOTE=ANSI PROC SQL Option to override this default renaming algorithm. In the following example, a connection is ...