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 |
|
Sully
Starting Member
30 Posts |
 Posted - 2005-05-10 : 15:29:59
|
| Hi All,I have searched this site and microsoft as well, for this problem. I'm using xp_sendmail on an insert trigger, with the recipient being a value from the inserted record. If the email address is a local address, xp_sendmail works perfectly fine. However, if the address is an internet address, I get the can't resolve error. Is this a SQL problem or setting, or an outside influence, like Outlook. I can send to internet addresses, using Outlook and the account that's running SQLServerAgent, on that server. We are using Windows 2003 Server, Outlook 2000 SR-1 Corporate or Workgroup, and MSSQL 2K SP3. Any thoughts, directions, answers will be appreciated.Stuck in neutral in a pedal to the metal world,Sully |
|
|
Sully
Starting Member
30 Posts |
Posted - 2005-05-11 : 09:55:42
|
| One more tidbit, I can send to an internet address through SQL by including that address in an operator, and sending a notification off a job completing.Stuck in neutral in a pedal to the metal world,Sully |
 |
|
|
|
|
|
|
|
Send Mail could not resolve recipient