I need to be able to detect when a row is written to a SQL Server table. Is it possible to create an event handler or something like that, so I can execute some VB.NET code whenever a record is written.



Thanks,

Tim

That is on the database side, if you are wanting to do this strictly within Strataframe at the application level, I think there is an AfterAddNew event (or something real close, I dont have SF loaded where I am right now)

Keith Chisarik

I should have provided some further details.



We are doing some integration to a third party SQL Server database and would like to know if I can detect when a record is written to a specific table. We don't have control on what/when data gets written and I can't touch the database in anyway.



I could write a SF windows service to periodically check the table for a record count, on a timer or something like that, however the data is written sporadically throughout the day and I was concerned about having a service continually check for a record. I was just looking for a better way.