USE yourdatabase
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MailToCustomerTr' AND type = 'TR')
DROP TRIGGER MailToCustomerTr
GO
CREATE TRIGGER MailToCustomerTr
ON rowInserted
FOR INSERT
AS
EXEC sp_send_dbmail @recipients = 'shg@hmau.com'
GO