Re: two questions

Hilary!

Just one more question.
It still bothers me about the first part of my previous question.
As I mentioned, I have 3 subscribers and 1 publisher.
I would like to filter data according to the NAME (server name) of the
subsrciber. If I use HOST_NAME() function, I get the name of the
publisher(distibuter) and not subscriber. Wich function or how do I set the
function to return the name of the subcriber?

Uros


"Hilary Cotter" wrote:

> 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
>
>
>
.