sql server replication: Hi
Can anyone guide me, I have following doubts.

I need to filter tables records to my subscribers dependign upon their
area for which I want to implement Dynamic filtering, now problem is
that some where I have read that for dynamic filtering I'll need to
implement Dynamic snapshot I don't know whatz that and what changes
Will I need to make to get this done, Also where and how to mention
filtering criteria In my case I just need to filtering only those
records from the table which belong to a sepcific user.

Firstly, this only applies to merge replication. It is
possible in transactional, but you'd have to have
transformable subscriptions and separate DTS pachages per
subscriber.
Anyway, in the publication wizard for merge, select 'yes,
I will define filters....', 'Horizontally', 'Enable
dynamic'. On the next form, enter the filter clause.
There is some info on this in BOL, but you have a choice
between the suser_sname(), host_name() and UDFs based on
these. These parameters can be automatically read on
synchronization, or overridden in the merge agent's
parameters.
Regards,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)