SQL Server and Trigger that send alerts

Does anyone know how to use a table trigger to send an alert. I know how to use it to monitor database errors but I'm not sure how to make the tirgger send an alert to me when someone enters data into a table for a trouble ticket system I developing. can you help me.
Denn

You would have to set up SQL Mail on the SQL Server.

Here's an article on it:
http://msdn.microsoft.com/library/d..._servp_2pt8.asp

Then you would write a stored procedure that sends the mail you want and call that stored procedure with the table trigger.

Or alternatively, you could write a stored procedure that both updates the table and sends mail.

OR alternatively, you could add a send mail function to the application that writes to the database.

So many choices