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:08:03
|
| robert writes "######################2.Mail, because first had a tipping mistake:'ribert@dellschau.de does not exist, please delete it from your mailing list!it must be 'robert@dellschau.de' Big big sorry !########################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" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-07-02 : 16:55:59
|
| Can you route incoming mail with "!SystemAdmin" to an alternate mailbox/folder? (Sorry if this doesn't make sense, I'm used to Outlook, and the ability to set up rules against incoming e-mail. Your Linux Mail Server may or may not have this functionality.)At the extreme, you may try to route ALL incoming mail to an alternative mailbox for 'scrubbing' before forwarding it on to SQL Mail. |
 |
|
|
|
|
|
|
|
SQL-Mail -- Receiver of generated mail does not exist