assuming the replication job relicates views that are associated with the
tables. Is there a way to only replicate the table and not the view?
I'm not sure I follow this

If so, please can you post it up. If you just want to replicate the table
and not the view, sp_dropsubscription and sp_droparticle should do it for
you eg
sp_dropsubscription @.publication = 'northwindxxx'
, @.article = 'regionview'
, @.subscriber = 'pll-lt-16'
sp_droparticle @.publication = 'northwindxxx'
, @.article = 'regionview'
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)1
No comments:
Post a Comment