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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-15 : 10:05:01
|
| kandarp writes "I am storing different dates in a database in sql 7. On this particular date/s; sql should by itself execute a stored procedure and send a mail using CDONTS object..Is that possible and how ?Thanks in advance...." |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-03-15 : 10:12:24
|
| There's some code here that sends an email from SQl Server using CDONTS - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=10447You could use this from a job if you want to send an email at a particular time under a particular condition, or you could fire it from a trigger if you want to check for a particular kind of data on insert into the table |
 |
|
|
|
|
|
SQL and cdonts funstionality