locked
Notification Services & Triggers RRS feed

  • Question

  • Hello All,

    perhaps a stupid question,

    Notification Services replace triggers to detect changes in a database table ?

    Olivier

    Tuesday, March 14, 2006 1:48 PM

Answers

  • You can use SQLNS to notify you when changes have been made to a table in a could of different ways.

    First you can configure the SQL Server Event Provider to query the target table and to recognize the newly created or changed rows. Essentially, SQLNS will poll the target table on a periodic basis looking for changes. You write TSQL queries to identify the changes. You can even perform a post query to update the rows to mark them as having been processed.

    The second way is to call some SQLNS stored procedures from a trigger created on target table and submit events that way. Check out ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/4a7b373a-b8ee-474b-b766-79c4fbae1057.htm for more info on the sprocs.

    HTH...

    Tuesday, April 4, 2006 11:51 AM