all groups > sql server replication > april 2007 >
You're in the

sql server replication

group:

Query notifications and replication


Query notifications and replication sqlboy2000
4/13/2007 12:48:01 PM
sql server replication:
Anyone using query notifications with replication? We have a replicated db
(transactional one way) and I have to turn service broker on for an app that
will use query notifications and I was wondering what effect that will have
on replication.

Thanks in advance.
RE: Query notifications and replication Paul Ibison
4/13/2007 3:08:02 PM
According to my understanding of NS, apart from the resultant use of system
resources, there isn't really any overlap. There could be an impact if
Notification Services is polling the same tables on the subscriber that are
being replicated to - the usual blocking that would occur with any such
queries.

Paul Ibison
AddThis Social Bookmark Button