February 27, 2006 at 12:37 am
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
Anybody !!!!
March 1, 2006 at 11:37 pm
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