Filtering column data in SQL Server 2008 R2 Transactional Replication

Question

Is it possible to filter the data content of columns published in standard transactional replication of a SQL Server 2008 R2 database?

If I filter the columns themselves, they vanish entirely in the subscriber tables. I want the columns to exist, but be empty regardless of whether there is data in that column on the publisher side.

Thanks much in advance.

Answer 1

Yes, this can be done by adding the columns using a post-snapshot script. Have a look at Execute Scripts Before and After the Snapshot Is Applied.

Answer 2

Not out of the box, but you could hack the subscriber procedures to do that.