Thank you very much for the steps. I looked at msdn on sp_send_dbmail and a couple of stackoverflow threads on how to work with DB MAIL and I think I won't get it. A lot of it goes over my head and it will take a lot of time for me to learn. So I will duplicate the procedure of emailing from ASP.NET application (I have done it before in another ASP.NET app and I know how to do it). And then I will have to duplicate it for iOS application too. I know a lot of work but at least I know more or less how to do it.
>One of the way to handle it
>1. Create a table to store changes
>2. Create a trigger to dump changes into the table
>3. Create a JOB to check the table and send email using DB MAIL
>
>Hard to tell if it will work for you w/o additional info
>
>>
>>Is it possible to set some kind of a 'trigger' that SQL server would send an email when a certain field(s) changes value? Currently this feature is done in the VFP 9 application. I am thinking of how to "move" this procedure from the VFP program to the SQL. Of course, if this is possible.
>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham