Not sure if this is the proper place to post this. I have a 3rd party application that periodically will push data to our table real time or every 5 minutes. These tables are just dump tables that will store all downloads from the 3rd party
app. When the data is inserted into the dump tables, I need a client to process to massage the data, do some calculations, clean up and push them to production tables. W/o using triggers, how can I automatically let the client know that new
data has been received from Sql Server.
View Complete Post