BR><BR>This machine already has a SQL Server 2005 installation, and it uses the wrong collation (case insensitive/accent insensitive when I need case insensitive/accent sensitive, I think).< ...

SQL Server 2000<BR><BR>I need to change the collation for a database from case senstitive to case insensitive. <BR><BR><pre class="ip-ubbcode-code-pre">ALTER DATABASE ...

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.