-
xp_sendmail how many of you have problem with it ?
Hello everybody.
Periodicly I have problem with xp_sendmail.xp_sendmail starts but never finish ,I can't stop it by exec xp_stopmail.
The only way restart server
I am running WIN2000 SQL2000 Enterprise edition Sp2.
No changes done on Exchange
No Changes done on Profile
I am sending Excel files as attachments
My Sql agent mail for job notification run fine.
What could be possible problem with my mail ?
-
xp_sendmail how many of you have problem with it ? (reply)
open outlook using the same exchange account and email the same recipient being used the xp_sendmail stalls. it may be an exchange issue or issue with resolving the recipient.
------------
Alex at 5/2/2002 10:41:25 AM
Hello everybody.
Periodicly I have problem with xp_sendmail.xp_sendmail starts but never finish ,I can't stop it by exec xp_stopmail.
The only way restart server
I am running WIN2000 SQL2000 Enterprise edition Sp2.
No changes done on Exchange
No Changes done on Profile
I am sending Excel files as attachments
My Sql agent mail for job notification run fine.
What could be possible problem with my mail ?
-
xp_sendmail how many of you have problem with it ? (reply)
I tried , mail goes fine when send from outlook directly.
All mail send by xp_sendmail freeze again tonight.
I will exclude one by one evry job or program that use xp_sendmail
but any help would appreciated.
Thank you.
Alex
------------
dba723 at 5/2/2002 3:39:09 PM
open outlook using the same exchange account and email the same recipient being used the xp_sendmail stalls. it may be an exchange issue or issue with resolving the recipient.
------------
Alex at 5/2/2002 10:41:25 AM
Hello everybody.
Periodicly I have problem with xp_sendmail.xp_sendmail starts but never finish ,I can't stop it by exec xp_stopmail.
The only way restart server
I am running WIN2000 SQL2000 Enterprise edition Sp2.
No changes done on Exchange
No Changes done on Profile
I am sending Excel files as attachments
My Sql agent mail for job notification run fine.
What could be possible problem with my mail ?
-
xp_sendmail how many of you have problem with it ? (reply)
Alex, my configuration is a little different than yours but I was having a similar problem with xp_sendmail, then I read some where that sqlmap70.dll delivered with service pack 2 has some bugs in it, I replaced it with the one from service pack 1, and now I can start/stop mail without any problems (so far).
------------
Alex at 5/2/2002 10:41:25 AM
Hello everybody.
Periodicly I have problem with xp_sendmail.xp_sendmail starts but never finish ,I can't stop it by exec xp_stopmail.
The only way restart server
I am running WIN2000 SQL2000 Enterprise edition Sp2.
No changes done on Exchange
No Changes done on Profile
I am sending Excel files as attachments
My Sql agent mail for job notification run fine.
What could be possible problem with my mail ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|