Better technique to send mail if new record inserted

Question

I have a form to fill details, those records will inserted in db with columns name, email, phone, ismailsent. now i want to send an email to my admin team if any new record inserted into DB. any better technique like windows service, i want it to be very clean. any help appriciated

i thought create `sql server trigger` is better than create window service. or after you insert value you send email with c# mail functionality — Sabilv, Jun 12 '13 at 09:04
@sabil that might put too much load on db right. i am looking for faster and lighter way — charan, Jun 18 '13 at 08:25
@charan so why not try to send email, after you success insert the data on your c# code behind, or if you use SP, how about insert email code there. — Sabilv, Jun 18 '13 at 09:17

score 0 · Answer 1 · edited May 23 '17 at 10:25

0

You don't give any details, but I guess you're looking for something like a database trigger. I don't know which DBMS you're using, but take a look at this post: C# / SQL Listener to tell me if a row has been inserted into a table

edited May 23 '17 at 10:25

Community

1
1

answered Jun 12 '13 at 07:19

Rob

11,492
14
59
94

Then this is what you need: http://stackoverflow.com/questions/1355921/sql-server-2008-help-writing-simple-insert-trigger – Rob Jun 12 '13 at 07:25

score 0 · Answer 2 · edited May 23 '17 at 12:13

There are a few options for achieving this functionality, you could have a windows service or a web service which you invoke after you insert your record successfully, or you could use the SQL Server 2008 build in functionality (sp_send_dbmail), but you first need to configure it. Here are some posts that might help you:

Hope it helps. Cheers!

Better technique to send mail if new record inserted

2 Answers2