Connecting Tech Pros Worldwide Help | Site Map

Notificate by sending an email automatically

Newbie
 
Join Date: Sep 2009
Posts: 5
#1: 1 Week Ago
Hi all,

I am using ASP.NET & SQL Server 2005. Whenever there are changes in database, I need to send an email automatically to administrator.

I am very please if you can tell me how I can "send an email automatically to administrator" when programming with C#?

Thank you very much!
tlhintoq's Avatar
Moderator
 
Join Date: Mar 2008
Location: Arizona, USA
Posts: 1,743
#2: 1 Week Ago

re: Notificate by sending an email automatically


I would recommend you start with just sending an email.
Learn how to do that much. Then worry about the 'automatic' part, and reacting to a database change secondly.
Frinavale's Avatar
Site Moderator
 
Join Date: Oct 2006
Location: The Great White North
Posts: 5,066
#3: 1 Week Ago

re: Notificate by sending an email automatically


I don't see how this has anything to do with ASP.NET
It seems to me that you are interested in configuring your MS SQL server to send an email when an event happens (like insert or update). You can do this using Triggers.

Check out this article on Creating Email Triggers in SQL Server 2005.

-Frinny
Reply

Tags
email, notificate