According to BOL...

CREATE TRIGGER permissions default to the table owner on which the trigger is defined, the sysadmin fixed server role, and members of the db_owner and db_ddladmin fixed database...

ARGH! To think of all the pain and suffering I've gone through when I could have used...

SELECT @var = @var + IsNull(colx + ', ', '') FROM tblX WHERE...

Question to MSSQL gurus about mromm's answer...

Using UNION instead of UNION ALL causes MSSQL to sort the results to remove duplicate rows. However, the WHERE condition of the 2...