February 17, 2002 at 11:49 pm
I tried to execute xp_sendmail function based on below statement :-
EXEC xp_sendmail 'wilda@pmrdc.msft',
@subject = 'Query Result: Total Products'
and I got below error message :-
Your message did not reach some or all of the intended recipients.
Subject:Query Result: Total Products
Sent:2/18/2002 1:49 PM
The following recipient(s) could not be reached:
'=SMTP:wilda@pmrdc.com.my' on 2/18/2002 1:49 PM
No transport provider was available for delivery to this recipient.
Please help..
tq
kenari
kenari
February 17, 2002 at 11:58 pm
It looks like SQL Mail did its part. The problem is the address that was attempted.
Doing a quick WHOIS, I can't pull up pmrdc.com or pmrdc.com.my so the error makes sense. Basically, your SMTP server will attempt to go find the proper mail server for the given domain. For instance, if you had mail destined for hotmail.com, the SMTP server will attempt to find out an appropriate mail server for hotmail.com using DNS. When it finds one with the highest "preference," it'll send the mail message out. However, since those domains don't exist, the SMTP server can't query the DNS servers to find out the appropriate mail server.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply