[Top] [All Lists]

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

Subject: Re: Notification services or another mechanism .. how do I ...
From: Joe Webb
Date: Wed, 15 Aug 2007 04:22:08 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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
Notification Services. 

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.



Joe Webb
SQL Server MVP

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