Friday, February 24, 2012

Delete Rows At The Publisher

I have some rows I need to delete at the publisher but I don't want to
replicate these deletes to the subscribers. Is there any easy way to do
this?
tia
Tina
Tina - what type of replication are you using?
rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I'm using merge replication.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23wR$X61xEHA.2348@.TK2MSFTNGP12.phx.gbl...
> Tina - what type of replication are you using?
> rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||It's easier for transactional, but for merge, you could
disable the triggers on these tables then make the
changes then reenable the triggers.
rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Sounds easy enough.
Thanks Paul!
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:4cb001c4c7d3$ac18cd70$a401280a@.phx.gbl...
> It's easier for transactional, but for merge, you could
> disable the triggers on these tables then make the
> changes then reenable the triggers.
> rgds,
> 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