SQL Server Message 93 SL 2018 CU2

(0) Share

Report

Posted on by The New Recruit

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?

All responses (2)

Answers (1)

The New Recruit on at

Like (0)

Report

RE: SQL Server Message 93 SL 2018 CU2

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

Brian_IL 715 on at

Like (0)

Report

RE: SQL Server Message 93 SL 2018 CU2

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.