one thing you can do is add a sql agent job which calls vn application and schedule job to execute based on a regular period. have a control table to indicate whether record is updated. job checks this table and does application call only when control bit is set (record updated)
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
The obvious thought that comes to mind when you say "AUTOMATICALLY TRIGGER" is an update trigger on the table. However, I would be very weary about doing that for all kinds of reasons - data integrity, performance etc. So if you don't need "live" updates I would go with a scheduled task as Visakh suggested.
Database Trigger
Posted - 02/02/2013 : 06:39:06
