Also, if you want that trigger to send you email, you will need to turn on Database Mail (DBMail) in order to use it.

To get you started, here is a simple script to send a message, once DBMail is turned on and set up.

--simple message

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'SQL Server Agent Mail Profile', -- this should be the actual profile name you give it when set up

@recipients = 'someaddres@somecompany.com',-- use ; between them if more than one

@body = 'This is a test of the emergency broadcast system....',

@subject = 'This is only a test' ;