You can do this by using extended stored procedures xp_sendmail, xp_startmail.
This is the sample code.
create trigger sendmail
on my table
for insert, update, delete
as
exec master..xp_sendmail 'xyz@yahoo.com', 'changes happend in database'
this is a sample one only. see the transact sql...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.