Post reply

Sending Message to Client application

  • February 27, 2006 at 12:37 am

    #152782

     

    SCENERIO:

    We have a client/server application with Access/SQL Server.  We have one table which keeps record of new developments in the database.  We want to inform all the logged in users if there's a new update available.  How we can do it? I was able to create a trigger with RAISERROR for AFTER INSERT operation. RAISERROR is displaying the message but after displaying the message, INSERT operation is failed.

    QUESTION:

    After I insert a new record in any table, how to pass a custom message to client application that there are new updates available.

    Regards,

  • February 27, 2006 at 9:05 am

    #623480

    Anybody !!!!

  • March 1, 2006 at 11:37 pm

    #624197

    yep coz you raised an error...

    use xp_sendmail or some sendmail application that you can call whenever an insert is done

    a trigger will do nicely i think... or you can do it periodically through a job like every 15 minutes or 30 minutes

     

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

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