Home Forums SQL Server 2008 SQL Server 2008 Administration Create DML trigger for single table in SQL 2008 and send email alert to group RE: Create DML trigger for single table in SQL 2008 and send email alert to group

  • April 16, 2013 at 1:57 pm

    #1607031

    krishnavenkat16 (4/16/2013)

    Hey Tom,

    Here what i'm getting....

    for insert...new records are logged - with this requester can know what record is inserted

    for update....old records are logged - with this Requester will know what has been updated

    for delete ....deleted records are logged - with this Requester will know what has been deleted

    fyi, i have removed the comment on @optype = 3

    i guess this result is fine....please let me know if i need to update the code...

    Yes, removing that comnment fixes it. I don't see any other problem. Glad you've got something that works - it took a while for us to help you there.

    Tom