All,

We have filtered Merge Replication implemented on some tables in a
database. We need to schedule Snapshot agent to fire every 2 hrs. Problem
with this Snapshot agent is that it starts locking and blocking other
processes and noone can do their operations. Please advise.... Thanks.

- Ashish Viradia.
MS Sql Server LazyDBA home page