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-05-24 : 09:43:53
|
| Mark Greene writes "I read the aritcle SQLMail in Depth, but Im a little confussed as to how to send mail to a sql server. DOes it just use the profile i've already set up? ALso, right now I'm learning SQL Mail from scratch and im a little foggy on stored procedures. Do you think you could how me an exmaple of one that would process inbound mail? Thank you very much.Mark" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-24 : 11:26:55
|
| sp_processmailxp_readmailThese are some additional stored procedures that allow SQL to access the SQLMAIL account you've set up.Mail is sent to the SQL Severs mail account, and it is the responsibility of SQL Server to 'pick it up'.Look up xp_readmail in the TRANSACT SQL HELP to find references to other stored procedures that allow you to step through your mail messages, process and delete them. |
 |
|
|
|
|
|
SQL Mail