S Sylesh Nair Nov 21, 2003 #1 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
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
R R.Balaji Nov 21, 2003 #2 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
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