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