Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What are the steps to make a schema change to a SQL Server 2005 database using transactional replication?

I'm trying to add a database column. I thought if I removed the article for the table, made the schema change, and then added the article for the table back that the schema change would replicate. I am now getting the following error every minute or so:

SQL Server errors
Replication-Replication Distribution Subsystem: agent [jobname] failed.
Invalid column name 'NewColumn'.

share|improve this question

You need to reinitialize the subscriber from a snapshot to pick up the schema change.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.