• I wouldn't do this in a trigger.

    Use the trigger to insert into a table then have a scheduled job which polls the table and does the processing when an entry appears.

    In that way you have a record of what's been processed and done hold up/error the system due to email issues.


    Cursors never.
    DTS - only when needed and never to control.