Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BankOfficerHere
Posting Yak Master
124 Posts |
 Posted - 2009-08-07 : 05:54:23
|
| Hi,,Is there a way that when email is sent to the address, it will automatically update the table with dates sent.thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-08-07 : 10:47:21
|
| In whatever process you use to call the send-mail SP can you also add (or update) a row in the table? Perhaps if you place the send-mail call in a try/catch block then update the table after the call but still before the end try. The catch block can take appropriate actions if there was an error detected.Be One with the OptimizerTG |
 |
|
|
|
|
|
Send SMTP Email using SQL Server and upate table