Sunday, March 25, 2012

Can not copy view

I have a replication job that can not replicate a view. Any ideas? I am
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 Do you get an error when replicating the view?
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