Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

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.