25 Agustus 2011 16:24
i'm new to notification services and before digging into it i'd like to make sure that this is the technology i need.
i want to implement continuous queries that process data streams with sql server. a continuous query should act like the condition part of a trigger: it should listen to a data source that produces a data stream and process each element on the stream as soon as it arrives.
is notification services what i'm looking for?
30 Agustus 2011 5:58
A Notification Services application (or "notification application") generates and sends messages to users or other applications that have subscribed to the application.
Introducing SQL Server Notification Services
Microsoft SQL Server Notification Services Technical Overview
According to your description, I think SQL Service Broker can meet your needs. Service Broker provides queuing and reliable messaging for SQL Server. With Service Broker, internal or external processes can send and receive guaranteed, asynchronous messaging by using extensions to Transact-SQL.
Overview (Service Broker)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.
- Ditandai sebagai Jawaban oleh KJian_ 05 September 2011 7:59
21 Nopember 2011 17:53
You may be more interested in the SQL 2008 Streaminsight (Complex Event Processing). This is more of constantly running engine.
It is a little more steep on the learning curve than what Notification Services was (it not longer is a product, removed since SQL 2008).