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 - 2002-07-02 : 11:07:43
|
| robert writes "Hi @ sql-team !Yes, I did the harakiri to set up sql-mail ... finaly with the helb of yur website, it works fine. But there is one big problem:My sql-server works behind a linux box, configurated to send out all emails with sendmail -- normally the best way to transport a lot of emails. I own about 2000 email addresses, maintained by sql 7.0 server data-table ... subscirbung / unsubscribing and getting infos is done by the sql-server. This all works fine, except, that it happens, you get emails back with addresses like '.@.de' or ' ', even worse, 'notexistant_user'@notexistant_domain.com' or anything else... sql-server now want's to answer this addresses, creates with xp_sendmail the email, sends it off, but sendmail doesn't accept the transport, because it can't resolve the emailaddress. The email ist rejected to sql-server, the head sais onlyfrom: "!Systemadminstator"subject:"Unzustellbar (undeliverable) :...."text blablaNow, SQLMail stops. And this is the worst case, because you wont manage to delete this email wiht xp_deletemail, because sql-mail is down ...Do you have an answer for this ?regardsRobert dellschau" |
|
|
|
|
|
|
|
SQL-Mail -- Receiver of generated mail does not exist