View Single Post
Old February 7th, 2008, 07:30 PM
robprell robprell is offline
Friend of Wrox
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts

You may want to consider doing a trigger.

Depends on the volume of data your dealing with. A trigger can be setup when you insert or update a value in table one. It fires and takes that data and can send it to a remote location. In your design if no records changed, you would fire the stored proc off 60 times an hour. A trigger fires off for every insert, update or delete or whatever you set it up for.