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

SELECT STRING_AGG (CASE WHEN pc.name COLLATE DATABASE_DEFAULT = @column_name AND @new_column_name > N'' THEN QUOTENAME (@new_column_name) ELSE QUOTENAME (pc.name COLLATE DATABASE_DEFAULT) END, N', ') ...