Better way to send mail when data is entered on sql table..Net program or by SQl trigger?

Question

0.00/5 (No votes)

See more:

Hi,

I wish to send a mail to group of user once data is entered in a particular table.I am not sure which way to use,should I go for .Net program or should I use db_mail functioanlity of Sql Server.

I was thinking of writing a trigger to send a mail once data is entered in table.
Can you please suggest the best option to do it.

Thanks in advance

Posted 27-Mar-14 5:54am

vicvis

Updated 27-Mar-14 5:55am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2014-03-27T06:30:00

Solution 1

Triggers are a bad idea, since there is the potential to block the database, and in any case emails require retries etc. and are bound to the network latency.

You are better off creating a service for this with retry and notification.

Posted 27-Mar-14 6:30am

Mehdi Gholam

Comments

vicvis 1-Apr-14 4:41am

Thanks for your reply.What you mean to say is taht I should write a window service in .net and ping database from it constantly?but wont that cause much CPU utilization.

I am sorry to ask this as windaow service is not my area of work and i am not preety sure of what CPU will it have.

Mehdi Gholam 1-Apr-14 11:05am

Cpu utilization will not be a problem.