Re: two questions

1) either create three different publishers each one with its own filter, or
use dynamic snapshots. I take it you have a criteria to filter on.
2) With transactional replication you can replicate the execution of stored
procedures. In the specify articles dialog of your publication wizard, click
on the browse button to the right of your stored procedure and select the
other tab. Then select the Every time it is executed. There is also the
stored procedure sp_addscriptexec. This stored procedure when executed on
the publisher will execute the script referred to in the scriptfile
parameter on every unc deployed subscriber. It does not work with ftp.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"uros" <uros@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3ED15996-D159-4924-92AD-B72794A1B6CE@xxxxxxxxxxxxxxxx
> Hi everyone!
>
> I'm completely new in SQL Server 2000 Replication. I have two questions:
>
> 1. I have 3 subscribers and 1 publisher. I use push merge replication. The
> distributor runs on publisher. The publisher and distributer server name
is
> NEON, the subscribers name are GENESIS,PLUTON and VENERA.
> How do I set the dynamic filter that every subscriber would get only his
data?
>
> 2. I've red that if you make some stored procedure, publish it and than
exec
> it at publisher, only exec [some stored procedure] command will replicate
and
> not the result of the stored procedure. But I can't do this in my case. It
> replicates the result (I' looked at that in Profiler).
>
> Thank you for your answers,
> Uros


.

Loading