Send a mail, whenever a new record is inserted in a table using Sqlserver 2000

Here, we have to create a trigger on required table as show below.


CREATE TRIGGER reminder2
ON TableX
AFTER INSERT
AS

EXEC master..xp_sendmail
@recipients='you@you.com',
@message = 'body'
@subject = 'foo was fired.'
GO