Re: Notification services or another mechanism .. how do I ...
On Mon, 13 Aug 2007 11:11:58 +1000, Bob wrote:
> 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
You may want to look at Query Notifications, not the same thing as
If this is a new project, you should know that Microsoft has quietly
stated in the July CTP ReadMe file that SSNS will not be part of SQL
Server 2008. I would not consider using it for new development projects.
SQL Server MVP