Post reply

Can SQLServer Communicate to an SQL client app?

  • June 25, 2003 at 10:18 am

    #59457

    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.

  • June 25, 2003 at 10:38 am

    #463075

    You could create triggers in the tables that you need to audit, and make them send you by email or by net send a message that explains with table what modified and what column.

    You can also capture the before and after value of an update.

  • June 25, 2003 at 10:48 am

    #463078

    Setting up a SQL Server Alert may help. In EM go to your server -> Management -> SQL Server Agent -> Alerts. Find the parameters that will satisfy your requirements.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply