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

Notifications

Announcements

No record found.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans