Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Sql Message 76 in Dyna...
Microsoft Dynamics SL (Archived)

Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

(0) ShareShare
ReportReport
Posted on by Venedict 1,235
Hi All, Anyone encounter SQL message 76 when trying to send message through communicator? I had tested if manually run the insert statement below, the record is successful insert and email managed to send out. What could be the issue here? Below is the message displayed. --------------------------- SQL Server Message 76 --------------------------- [Microsoft][SQL Server Native Client 11.0][SQL Server]Mail (Id: 584) queued. Debugging info: insert pjcommun (crtd_datetime,crtd_prog,crtd_user,destination,destination_type,email_address,exe_caption1,exe_caption2,exe_caption3,exe_name1,exe_name2,exe_name3,exe_parm1,exe_parm2,exe_parm3,exe_type1,exe_type2,exe_type3,lupd_datetime,lupd_prog,lupd_user,mail_flag,msg_key,msg_status,msg_suffix,msg_text,msg_type,sender,source_function,subject) values( '02/21/2014 08:36:00:00', 'COMMT', 'KFINN', 'TEST', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '02/21/2014 08:36:00:00', 'COMMT', 'KFINN', '', 'TEST MURP01 2014/02/21 08:35:00:00', 'N', '00', '1234', 'MANUAL', 'MURP01', 'Send Messages', 'test') Cursor(c_PJCOMMUN) pjcommun_init Optional info: SqlState = 01000 NativeError = 0 ErrorMsg = [Microsoft][SQL Server Native Client 11.0][SQL Server]Mail (Id: 584) queued. pcbErrorMsg = 76 ODBCRowNumber = 1 Column = -1 SSrvrLine = 484 SSrvrMsgState = 1 SSrvrSeverity = 0 SSrvrProcname = sp_send_dbmail SSrvrS --------------------------- OK --------------------------- Thanks. Regards, Teh

*This post is locked for comments

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

    Mark,

    The @exclude_query_output=1 parameter in the Mail_Message trigger that has to be added for SL per the post from Carolyn K above. We have had a few sites contact support were their trigger is no longer working. They drop and re-create he trigger but forget to modify it.

    The sites we have had report issues are those that have recently upgraded from SL 2011 using BP to a newer version of SL using WebApps, they have moved or updated their SQL server meaning they have had to re-setup DBMail, or they have a new exchange server (O365) and they are re-configuring things. We also have a handful of sites that lost their hosted servers and are having to restore and rebuild. Since DBMail integrates there are alot of areas where a site might drop and recreate this trigger and forget the additional modification is needed.

    Hope this helps.

    Carolyn

    MSDSL Technical Support

  • Mark E Profile Picture
    Mark E 6,451 on at
    RE: Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

    Just had this issue pop up today unexpectedly, after years of successfully using the SQL Mail Trigger (since 2013).  Had to add @exclude_query_output=1 to resolve the issue, as indicated above.  No changes were made in SL or SQL that would have caused this, just started happening mid-day.  Anyone have an idea as to what environmental issue may have required this adjustment?

  • Community Member Profile Picture
    Community Member on at
    RE: Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

    Hi Carolyn:

    Where is the mail_message trigger found for editing?

    Thanks,

    Mike

  • Venedict Profile Picture
    Venedict 1,235 on at
    RE: Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

    Hi Carolyn,

    Thanks. Will try it out later.

    Regards,

    Teh

  • Verified answer
    Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

    Hi Teh,

    The Mail_Message trigger has a line like this:

    EXEC @retval =msdb.dbo.sp_send_dbmail,   @profile_name = 'Communicator', @recipients = @email

    Modify the line to exclude the query output, so it looks like this:

    EXEC @retval =msdb.dbo.sp_send_dbmail @exclude_query_output=1,   @profile_name = 'Communicator', @recipients = @email

    You need to modify the trigger wherever that line appears.  It may be in more than one place.

  • Venedict Profile Picture
    Venedict 1,235 on at
    RE: Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

    Hi Carolyn,

    Where should I add this parameter in?

    Thanks.

    Regards,

    Teh

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Sql Message 76 in Dynamics SL 2011 when try to send message from Communicator

    Hi Teh,

    We had one other report of this error.  The message you are seeing is just an information message coming from database mail.   There is a flag you can add when executing the sp_send_dbmail command that will suppress this message. Add the @exclude_query_output=1 parameter to suppress the “Mail (ID: XX) queued” message.   The email should still send OK, we are just suppressing the information message response coming back from database mail.

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

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans