There's xp_sendmail stored procedure but I would wary to use it in a trigger. I woul rather write data to another table and than use Sql Agent or even outside application to periodically check it and send email.

>Is it possible, using a SQL SP to generate an email that contains as content the values of the columns of the row that has just been inserted into a table?
>
>I know that there is an email facet associated with SQL Server but I have never played with it.
>
>Thanks in advance,
>
>CT