Windows Service monitoring a Database table ?

  • Thread starter Thread starter Sylesh Nair
  • Start date Start date
S

Sylesh Nair

could anyone give me a possible solution for a Windows Service (in C#)
listening to a table in a database for insertion or updation.


thanks
 
Hi,

Monitoring of a table can be done by means of triggers only.

We can create a extended stored procedure which will raise the event and
inform the windows service about the table activity (insertion/updation).

Call this extended stored procedure from the insertion/updation trigger for
each of the table.


Regards,
R.Balaji
 
Back
Top