Trapping a SQL Event in VB

[Nikoli]

I need to trigger an event whenever a sql database has a new record written to it.

Is there a simple method to do this? Running a loop that constantly checks the database isn't an option.


Thanks.

 

[jigesh]

You can create an insert trigger on the table. Which means that when a new record is added to the table in the sql database, the trigger attached to that table will be fired. In the trigger you can then do whatever you want.