Many Rows

I have an article with 70,000 rows in it. I need to run an update script
from the subscriber that will update all 70,00 rows. Is there anyway I can
prevent these changes from being replicated? I realize I can drop the
trigger so the rows are not added to msmerge_contents. I'm looking for a
more automated approach since my subscribers are running MSDE.
TIA
Tina
do a sync with your merge agent, make sure it is not running in continuous
mode. Then when it has completed and shut down, set the -ExchangeType
parameter to Download, then restart your merge agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tina Smith" <tb.smith@.earthlink.net> wrote in message
news:OGOALZ56EHA.936@.TK2MSFTNGP12.phx.gbl...
> I have an article with 70,000 rows in it. I need to run an update
script
> from the subscriber that will update all 70,00 rows. Is there anyway I
can
> prevent these changes from being replicated? I realize I can drop the
> trigger so the rows are not added to msmerge_contents. I'm looking for a
> more automated approach since my subscribers are running MSDE.
> TIA
> Tina
>
|||Thanks Hilary, I'll give it a shot.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23fqa4$B7EHA.1564@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> do a sync with your merge agent, make sure it is not running in continuous
> mode. Then when it has completed and shut down, set the -ExchangeType
> parameter to Download, then restart your merge agent.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Tina Smith" <tb.smith@.earthlink.net> wrote in message
> news:OGOALZ56EHA.936@.TK2MSFTNGP12.phx.gbl...
> script
> can
a
>