sql server replication: Is this the latest CTP? I'm reinstalling it tonight and will get back to
you.
Rgds,
Paul Ibison

[quoted text, click to view]

Hi,

I have a base table in publisher db. I have a column, using which i want to
filter it and replicate it to certain dbs. how do i dynamically do it ?

Like for eg, consider this table :

ID Project name center
1 A NY
2 B LON
3 C PAR

now, i want to filter using the column "center". if center = 'NY', then i
must direct it to a particular subscriber. if it is "LON" then it must be
directed to someother subscriber. also, i must accomplish this using merge
replication

for my requirement, i am not able to use multiple publishers to accomplish
it. i must use one publisher, with a filter which varies dynamically
depending on the subscriber.

please explain how i can accomplish this.

PS : I'm new to databases. sorry if this question is very basic

Hi Paul,

thanks for the reply. i'm able to understand the idea behind your
explanation. but i'm using SQL Server 2005, Beta 2. i'm not sure abt the
agents. i'm using the gui. can u pls explain how i shd do it using yukon, in
the gui ?


[quoted text, click to view]