[Top] [All Lists]

Notification services or another mechanism .. how do I ...

Subject: Notification services or another mechanism .. how do I ...
From: "Bob"
Date: Mon, 13 Aug 2007 11:11:58 +1000
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Greetings all,

I am browsing this newsgroup looking for a mechanism to notify my external 
application when there is a change in my database.
And I would like a push in the right direction to find the right mechanism.

I have seen discussion around notification services .. which I'll be off to 
read up on .. but I wonder if this is the appropriate mechanism or there is 
a better one.

My goal is thus ...

I have an aggregation database that at various intervals collects summary 
data from a number of satellite DB's in the field ... at the moment my 
management application simply polls the aggregation database looking for new 
rows .. ideally when my aggregation database has finished its collection 
cycle I'd like to "ping" the management application and tell it there is new 
data to slice-dice and spit out to the screen.

What is the best way to do this? ..
Running a mix of SQLServer 2005 Express and SQLServer 2005 full .. on a 
bunch of XP machines.

regards Bob 

<Prev in Thread] Current Thread [Next in Thread>