SQL Server Performance

raise alert

Discussion in 'SQL Server 2005 General Developer Questions' started by shankbond, Feb 11, 2010.

  1. shankbond New Member

    Hi,
    is it possible to raise an alert and send an email to an operator, when some value is inserted in a table? I don't want to raise an error here.
    Simply send an alert mail having a custom message whenever a new row is inserted.
    shankbond, Feb 11, 2010
    #2

  2. FrankKalis Moderator

    You could possibly create a trigger on INSERT to dump a row into a separate table and a job checking regularly that table and send a mail when new rows are inserted.
    FrankKalis, Feb 11, 2010
    #3

  3. shankbond New Member

    Hi Frank,
    I think that would waist server resources, it will just be a ( polling type method), is there some other way around?
    shankbond, Feb 11, 2010
    #4

  4. FrankKalis Moderator

    Service Broker?
    FrankKalis, Feb 11, 2010
    #5

Share This Page