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

External Since: Aug 13, 2007 Posts: 1

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

External Since: Apr 28, 2004 Posts: 118

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.

HTH...

Joe

--
Joe Webb
SQL Server MVP
http://www.sqlns.com