I've never used it, but I think Notification Services would work for you.
http://www.microsoft.com/sql/ns/default.asp>Hi is theres a way where in my VFP app will be notify if there is newly inserted record in SQL Srv Database? or lets say SQL server will notify VFP app that there is newly record inserted from web transaction.
>thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer