Pull Replication with Filter

Hello,
we are working with:
SQL Server 2000 SP 4, publicating a database and trying to filter data
with:
UserGroup = Host_Name()
on the subscriber (agent properties) we set:
-Hostname TW
Starting the subscription with the SyncManager works fine, but no data
with the criteria 'TW' was replicated to the subscriber.
This problem occurs all the time i try to work with the pull
replication. The same procedure on a push replication seems to be OK.
Also two of our customers have the problems and this begins to be a
very big problem for us. Somebody knows an solution. For me it seems to
be an MS SQL Bug?
Thanks for help
Tulio Mossorous
Are you using dynamic snapshots?
You have to do this to make it work or create a separate publication for
each subscriber.
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
"Tulio" <mossorous@.yahoo.de> wrote in message
news:1123439126.086812.143350@.z14g2000cwz.googlegr oups.com...
> Hello,
> we are working with:
> SQL Server 2000 SP 4, publicating a database and trying to filter data
> with:
> UserGroup = Host_Name()
> on the subscriber (agent properties) we set:
> -Hostname TW
> Starting the subscription with the SyncManager works fine, but no data
> with the criteria 'TW' was replicated to the subscriber.
> This problem occurs all the time i try to work with the pull
> replication. The same procedure on a push replication seems to be OK.
> Also two of our customers have the problems and this begins to be a
> very big problem for us. Somebody knows an solution. For me it seems to
> be an MS SQL Bug?
> Thanks for help
> Tulio Mossorous
>
|||Hello Hilary,
thanks for your help!
Yes, I'am using dynamic snapshot.
Regards
Tulio Mossorous
|||Hello again,
in a lot of posts users have problems with the dynamic filtering of a
pull replication. I tried the dynamic filtering for about 2 days,
without any result!
The dynamic snapshot don't get any data. What happens? An Bug?
Best regards
Tulio Mossorous
|||Hello again,
in a lot of posts users have problems with the dynamic filtering of a
pull replication. I tried the dynamic filtering for about 2 days,
without any result!
The dynamic snapshot don't get any data. What happens? A Bug?
Best regards
Tulio Mossorous