I just created my first trigger, and I feel proud... It's a simple one:
CREATE TRIGGER TriggerName ON Users FOR DELETE AS
EXEC master..xp_sendmail 'Recipient Name', 'User deleted from
I'd love it if I could have the e-mail say:
'User ' + The value of a particular column from the row that was deleted '
was deleted from such-and-such system.'
From reading the BOL, it seems that I'll need to find an alternative method
of doing what I want to do, going by this quote from BOL:
A trigger is designed to check or change ...