sqldatabasews-eventing

What is the best way to implement a SQL(database) Listener?


What is the best way to implement a generic database which monitor a table and trigger an event(ws-event) when the table get updated. Is there any standard way to do this?


Solution

  • I think you are looking for a database table trigger:

    http://www.sqlteam.com/article/an-introduction-to-triggers-part-i