Post reply

xp_sendmail is hanging(SQL Server 2000/sp4)

  • May 5, 2008 at 1:13 pm

    #71254

    Hi All,

    I'm running one SQL Server 2000 sp4 and my problem is that the xp_sendmail

    is hanging .

    I tried the follow in order to solve this problem:

    - xp_stopmail ('Server: Msg 17955, Level 16, State 1, Line 0 xp_stopmail:

    Failed to stop SQL Mail session.)

    - killing all of the processes trying to send emails (they do not die, just

    sit in a KILLED/ ROLLBACK status)

    - tried locating MAPISP32 process running on the server (not there)

    - dbcc sqlmap70(free) (DBCC cannot free DLL 'sqlmap70.dll'. The DLL is in

    use.)

    - drop all xp referencing sqlmap70 and recreating (no change)

    - have even tried deleting SQLMAP70.dll after making a backup (access

    denied, file in use, but I can't see in open files on the server)

    So any idea about this problem?

    Thanks ,

    Serge

  • May 6, 2008 at 2:09 pm

    #811467

    I too had a heck of problems with xp_sendmail and the after testing on different servers, I implemented sp_send_cdosysmail on most of the servers and as of now doesnot have any problem.

    you can consider using a different solution, that doesn't have so many rooted ties into SQL Mail and OS and MAPI etc? For example xp_smtp_sendmail only requires an SMTP server that accepts relays from your SQL Server.

    or you can try sp_send_cdosysmail -- Trythis

    SQL DBA.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply