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