Replication

SQL Server replication: procedures for managing transactional replication, including adding columns to a replicated table.

Let a user who is neither sysadmin nor db_owner add columns to a replicated table by altering the tr_MStran_altertable trigger.