Showing posts with label couple. Show all posts
Showing posts with label couple. Show all posts

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)