Sending a message from a trigger

From: Gabi (Gabi_at_discussions.microsoft.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 12:09:05 -0800

Hi!
Is it possible to send a message to a user when a certain condition becomes
true in a trigger on a table?
I have a SQL Server 2000 back end and a VB6 front end and I would like the
user to be notified (through a message box) when a field in a table has a
specific value. Right now I have a timer that queries the table every 5
seconds, but I would like to create a trigger instead and send a message to
the user when the condition becomes true.

Thank you!

Relevant Pages

  • Re: Records not inserting...
    ... > I am totally new to SQL server. ... However, in a trigger, would I be ... test the effects of certain data modifications and to set conditions for ... UPDATE statements. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Help for an Oracle Newbie
    ... application I wrote using SQL Server ported over to Oracle. ... Obviously there are several built in data types in SQL Server that do ... Of course I had to use a different name for the trigger under each ...
    (comp.databases.oracle.server)
  • Re: TRIGGER (AFTER INSERT) and Store Procedure ... insert failed !
    ... >into SQL server, the record exist anyway! ... >If you refresh the data you will see the record... ... it gets refreshed after trigger excecution automatically. ... I don't know your monitoring system, but I guess that removing the result ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance and second table
    ... There is lot of evaluations ... SQL Server doesn't know that the data in both tables is ... down because the trigger has to be executed. ... keeping other queries blocked for longer ...
    (comp.databases.ms-sqlserver)
  • Re: Help for an Oracle Newbie
    ... application I wrote using SQL Server ported over to Oracle. ... Obviously there are several built in data types in SQL Server that do ... Of course I had to use a different name for the trigger under each ... In SQL Server I always create a CreatedDate column ...
    (comp.databases.oracle.server)