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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

SQL Server Message 93 SL 2018 CU2

(0) ShareShare
ReportReport
Posted on by

Working with a client work reported SQL Server Message 93. Been checking online and seeing some solutions on other SL threads which used the solution:

alter Proc Batch_Mod_Rlsed @parm1 varchar ( 10), @parm2 varchar ( 2) as

set nocount on

Select * from Batch with (nolock)

where BatNbr = @parm1

and Module = @parm2

and Rlsed = 1

which I used and it said that was completed successfully. However, when testing vouchers for release, it hangs up and produces the error. What I have had to do to get around it so far is to terminate the Release AP Batches screen in task manager, then re-open the screen to confirm that the batch has been released. Checked manual check/payment entry and the voucher shows up there. But that isnt a viable solution as it is constantly happening, even in other modules. Microsoft has given solutions but those were for SL 2011. Is there anything more current that could be suggested as a possible solution?


pastedimage1665598060137v1.png

I have the same question (0)
  • Verified answer
    Brian_IL Profile Picture
    719 on at

    It looks like that installation may have used FRx previously, and the FRx triggers didn't originally include the "set nocount on" statement.

    The FRx_SL2011_93Fix.SQL script updated the FRx triggers to use the desired syntax; running it would fix the error 93 problem if caused by FRx. If the client isn't using FRx now, any triggers left from the previous setup should be deleted.

  • The New Recruit Profile Picture
    on at

    I had eventually discovered that, what I did was to disable those triggers in the sql and then the issue was resolved.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 389 Super User 2026 Season 1

#2
Subra Profile Picture

Subra 373

#3
Martin Dráb Profile Picture

Martin Dráb 251 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans