Hi,
I would appreciate any leads/help I get in this direction.
Is there is way to set up 'Listeners' on the client end, which will inform my client application when some critical data has changed in the database?
At the moment, I will have to poll for changes to my table at a time interval, but, will it not be better if the server will give a message?
(Good example is, as I compose this message, I see a check box titled 'Check here to be notified by email whenever someone replies to your topic.' Thats exactely what I would like SQL Server to do for me!)
Thanks in anticipation.