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 |
|
PhilWang
Starting Member
1 Post |
 Posted - 2002-04-08 : 11:33:02
|
| Hi, Everybody,It is a very useful tool we want to evaluate. But it did not work fine.Here is what I did.1. RegSrv32 SMTPSVG.DLL ---Successfull2. Create sp_SMTPMail (default smtp server points to my smtpserver)3. Run the sp_SMTPMail as exec sp_SMTPMail @SenderName='Phil Wang', @SenderAddress='PWang@AirIQ.com', @RecipientName = 'Phil Wang', @RecipientAddress = 'PWang@AirIQ.com', @Subject='SQL Test', @body='Hello, this is a test email from SQL Server'I got return as Column1 ----------- 1(1 row(s) affected)Column1 ----------- 0(1 row(s) affected)4. Check my outlook and could not find incoming email.What is the possible reason?Thanks.Phil Wang |
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-04-08 : 11:41:13
|
| could you post the code of sp_SMTPMailSMTPSVG.DLL is a COM object for ASPMail from http://www.serverobjects.com, I believe.If we could take a look at your sp_SMTPMail code we might be able to help you out. |
 |
|
|
|
|
|
could not received email although sp run through