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 |
|
nicemate
Starting Member
3 Posts |
 Posted - 2004-07-22 : 11:00:44
|
| I am developing an application where a table contains the user profile information. When a user clicks on forget password then I want to have the facility that the e-mail address submitted by him is taken & email is send to him automatically using the xp_sendmail procedure. But i dont know how to configure it to use accordingly.Cna anyone help me. Thanks.regards,ANSHUMAN |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-22 : 11:37:30
|
| ??? Show us what you have so far. And what does this sentence mean???But i dont know how to configure it to use accordingly.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
nicemate
Starting Member
3 Posts |
Posted - 2004-07-22 : 14:40:42
|
| Ok Leave about the scenario. The thing is like that i have to use the facility of sending mail to different peoples whose email is stored in a table. To send them mail automatically by picking the email from the table & using the sored procedure xp_sendmail(an extended procedure stored in DB "Master") we have to configure the database to use a mail client. But i dont know how to do it. So in short i wanna know how to configure the MSSQL Server 2000 database to use a mail client to send mail using xp_procedure. If i can know that, i can use it to send mail to a user, who clicks on a link in the front end & thus capturing this action to fire a trigger at the database.I hope that i make myself more clear to you.regards,ANSHUMAN |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-22 : 14:45:59
|
| So do you have SQL Mail configured on the database server to use xp_sendmail. You must have a mail client installed on the database server to use SQL Mail. We use Outlook 2002. Here's an article on how to configure SQL Mail:http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556Tara |
|
|
|
|
|
|
How to configure automatic mailing, in MSSQL 2000