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 - 2003-08-13 : 08:05:57
|
| Hein writes "Hi I've created a stored procedure with the code in the example: Sending SMTP mail using a stored procedure.When I execute the sp, it says it was successfull, but I receive no mail.Further I've set the @MailServer variable to my companies mail server, but I still don't receive the mail. (should localhost work, and what software is required)Please can you help with my problemThanksHeinPS Using SQL server 2000" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-08-13 : 10:45:54
|
| Do you have the mail COM component installed on the database server ?If yes, ask your mail server admin to check the SMTP logs to see if it is recieving the message.If no, you need to install the component.Damian |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-08-13 : 10:59:40
|
| Are you sure your SMTP mail server is started and running?Sam |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-08-13 : 11:05:43
|
They wouldn't get ANY mail if it wasn't. Also, checking the log files will tell you that... if there are no log files, it ain't running  Damian |
|
|
|
|
|
|
SMTP mail example problem