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 |
|
heigui
Starting Member
1 Post |
 Posted - 2002-01-29 : 02:47:56
|
Hi,i would like to learn how to send email from sql server using stored procedures. Currently, the tools i have: windows98 sql server 7.0 w3jmailFirst,i would like to know what components need to be present to implement such a functionality?Secondly, to send any email i would need a mail server. Does it mean i can utilize the mail server name from any of my local ISP?i read thru the article posted at http://www.sqlteam.com/item.asp?ItemID=5003but cannot achieve the same result.PLS HELp. Appreciate much.you can reply me at hek_gemini76@yahoo.com as wellRgds,Learner |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-01-29 : 04:33:06
|
| That article uses CDONTS which should be installed if you have Personal Web Server installed uner Windows 98. What errors are you getting when you try the method shown in the article? Jack |
 |
|
|
shveta
Starting Member
3 Posts |
Posted - 2002-01-29 : 04:47:28
|
| That article uses ASPMail and not CDONTS. Did you install the SMTPSvg mailer component aka ASPMail? What values are you giving in remotehost? It has to point to a Mail Server. Your machine may not have a Mail Server, try using some Mail Server(maybe of your ISP) and executing it. |
|
|
|
jackstow
Posting Yak Master
160 Posts |
|
|
|
|
|
How to send email from SQL Server
Jack