web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Convert GP to switch t...
Microsoft Dynamics GP (Archived)

Convert GP to switch to sp_send_dbmail from xp_sendmail

(0) ShareShare
ReportReport
Posted on by Community Member

Hi, the company I work for uses GP10 and my manager asked me to set up business alerts. I managed to set everything up, both the alerts in GP and the database mail setup in SQL but cannot find how to switch GP to start using database mail (sp_send_dbmail) rather than the older version (xp_sendmail).

It is imperative for me to switch since the server SQL is running has no mail client software installed on it and hence cannot work with the older system.

Any one knows how or can lead me to a whitepaper stating how to achieve this?

Thanks and Regards

Jonathan Falzon

*This post is locked for comments

I have the same question (0)
  • soma Profile Picture
    soma 24,410 on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    No option available for changing GP mail(xp_sendmail) to database mail(sp_send_dbmail).

  • Community Member Profile Picture
    Community Member on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    Hi soma.

    Thank you for your reply, although I don't think that you are entirely correct since i were able to find threads on other forums stating this possibility.  What I cannot find is the white paper about it. A KB article 915097 explains the procedure involved although this article is not available to the general public. (A special microsoft account is required to access this article) hence that is why  I am asking here whether someone knows how the process required.

    Thanks once again

    Jonathan Falzon.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    Not sure what the question here actually is because db_mail is setup in SQL (which I assume you already know). Are you having a problem setting that up in SQL? The article you are referring to is located on CustomerSource which you should have access to if you have a support plain with Microsoft. Otherwise the KB is available externally as well. I just searched in it Bing and got the following:

    support.microsoft.com/.../de

  • Community Member Profile Picture
    Community Member on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    Hi Jonathan.

    Thanks for your reply. I managed to get access to customersource and to the KB article I requested but I am still having a problem with the Business Alerts setup.

    I have Database Mail set up and working correctly, updated the GP stored procedures using the scripts in the article but upon testing mail from GP Business Alerts an error window is popping up with the following message:  xp_sendmail: failed with error 0x80040111.

    Clearly this message shows that GP is still using xp_sendmail even after I ran the scripts highlighted in the KB article which should have switch GP from using xp_sendmail to sp_send_dbmail. (Upon running the alter stored procedure scripts I restarted the servers but still to no avail)

    Any help is greatly appreciated.

    Thanks and Regards

    Jonathan Falzon

  • Community Member Profile Picture
    Community Member on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    Hi, it's me again.

    I have tried to sort out the error 0x80040111 which was being given both in SQL Management Studio and in GP, and was able to sort out what was the problem. Running the test email for the SQL Mail returns success in SQL Management Studio.

    In GP however, upon testing the business alerts (which are using the xp_sendmail procedure) an error with the following code is returned: 0x80040700.

    Does anyone know what this means and how to sort it out?

    Thanks

    Jonathan Falzon

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    At this point you may want to open a support case. I have setup DB mail for GP and it should not be this complex.

  • JonathanCox Profile Picture
    JonathanCox 20 on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    When you send your test email via SSMS are you specifying the same recipient address as you used in GP? Is that address by chance a distribution group list?

  • Community Member Profile Picture
    Community Member on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    I have tried with both user mailboxes and distribution groups. Still gave me the same error.

    Thanks

  • Community Member Profile Picture
    Community Member on at
    RE: Convert GP to switch to sp_send_dbmail from xp_sendmail

    Jonathan,

    If you are using Business Alerts, it is using a stored procedure: smRuleSendMail - That procedure either uses the old xp_sendmail or the new sp_send_dbmail function. In GP 2013 SP2 on my server, it uses the new function. I think that process is controlled by the GP version, but you could look at the script and adjust to use the new function.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans