Notify by sending an email automatically

[Mai Phuong]

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]

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]

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

[Mai Phuong]

Thank you Mr Frinny! It helps me a lot ^^