I am having a lot of trouble figuring out the right way to get a trigger to work and was hoping to get some suggestions. I have spent more time than I care to admit on trying to figure this out. I ...

Within the trigger code we extract fields from table inserted, construct a message and then send this via e-mail using SQL Server's msdb.dbo.sp_send_dbmail stored procedure. Note that in the below ...