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 - 2001-12-14 : 10:55:55
|
| sachin s writes "Hi ,Recently I came across a facility called - SQL Mail of Sql server 7. I am going to use it my next project work.I want to configure it for my mail client Outlook express, so that SQL server can perform emailing using MS exchange server.I want to do one more thing ..i.e. Whenever there is one record added or inserted into a specific table of my database by any user, an email should be generated with some format and should be sent to that user instantly.Is it possible? And if yes, then what procedure should be written for that? Kindly send the answer in detail.Thanking you and waiting for the reply..Sachin" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-14 : 11:17:53
|
| Sachin,Your best bet for info on configuring SQL Mail is probably Books Online. As for sending a mail every time a record is inerted in a table, you could create a trigger to handle this, but I caution you to think this over a couple of times before you do it. If this table gets much activity the amount of mail could quickly get out of hand, not to mention the impact on performance to generate a bunch of emails.You might want to think about a scheduled job that would run every hour that would send an email reporting summary information of records that exist in that table, or some other sort of regular processing outside of a trigger.-------------------It's a SQL thing... |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
|
|
|
|
|
About SQL Mail...