Update value of column that is used for "Filter Rows" in Transactional Replication

Question

If I have set up Transactional Replication, and filtered the rows, what happens if I change the value of the column that is used in the "WHERE" clause of the row filter?

Example:

Filter:  WHERE [c1]= 'X'

And then I change the value of [c1] in a Row from 'X' to 'Y'?  It has been my experience that the replication command fails... is this correct? Or am I doing something wrong?

Thanks

---

Matt

Answer 1

After modifying a static row filter you will need to generate a new snapshot and reinitialize all subscriptions.

---

Brandon Williams (blog | linkedin)