Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • 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.

  • 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

  • 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?

  • 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.

  • 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

  • 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

  • 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 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.

  • 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).

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans