Home Forums SQL Server 2008 SQL Server Newbies How have Trigger's example after insert send to mail on outlook?. RE: How have Trigger's example after insert send to mail on outlook?.

  • January 30, 2013 at 2:23 am

    #1582520

    CREATE TRIGGER ... ON ...

    AFTER INSERT

    AS

    EXEC MSDB.dbo.sp_send_dbmail ...., ...., ...., ....

    Lookup database mail, configure it, and then put the right parameters into the sp_send_dbmail call that you need.