Monday, March 19, 2012

How to find replicated columns in published article

SQL 2000 trans replication.
I have a fat table (100+ columns ) being replicated minus a couple columns. .
How do I query the replication sys tables to find all columns being
replicated? Goal is to find which columns are NOT replicated.
Thanks in advance,
Chris
Chris,
sp_helparticlecolumns and the published bit will do the job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment