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

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

WHEN fk.delete_referential_action = 1 THEN N'ON DELETE CASCADE' WHEN fk.delete_referential_action = 2 THEN N'ON DELETE SET NULL' WHEN fk.delete_referential_action = 3 THEN N'ON DELETE SET DEFAULT' ...