sql server notification services: Hello

I have an existing application which requires notification when data is
inserted into a particular table. How can i write the event generation rule
for the same ?
Is it possible using SQL server 2k?

Thanks in advance

Regds
Rachel

Hi Rachel -

From the sound of your question, you don't already have a SQLNS
project in development, rather you are considering using SQLNS to meet
your needs. Is this right? If so, SQLNS may be used in the scenario
you described, but it may be a bit excessive.

You can use the built in SQL Server Event Provider to periodically
query the table in question, looking for newly added or updated rows.
The rule is simply a T-SQL query that you can use to identify the rows
of interest.

You may also use some SQLNS provided stored procedures to provide
events to your SQLNS application, calling them from a trigger defined
for your table of interest.

To notify an application, you'll need to develop a custom delivery
protocol but that's not a terribly complex undertaking.

All of this can be done in SQL Server 2000.

If SQL Server 2005 is an option for you, you may still use SQLNS but
there is another feature that may be of more interest to you - Query
Notifications.

HTH...


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


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

On Wed, 5 Oct 2005 04:53:09 -0700, rachel
[quoted text, click to view]