We have a customer running Windows Server 2012, SQL 2008 and DYnamics SL 2011 SP2, and when we try to release a bach, we get the following message:
SQL server message 93
The batch does release, but the error keeps showing.
I tried searching the Knowledge base but I'm getting the message:
Does anybody knows how to correct the customer situation?
*This post is locked for comments
When do you receive error 93? The most frequent occurrence was caused by the syntax used in the FRx index building SQL script. A hotfix was issued with the corrected syntax for the Set NoCount On statement.
Hi,
would this stored procedure work for SL
2015?
Hi,
would this stored procedure work for SL
2015?
Thank you Karthik
I’ll check on the customer site and will let you know if the problem is solved.
Hi,
There is a revised stored procedure that may help.
• Symptom - Deleting voucher hangs.
• Cause - Bug 23996
• Resolution - Running the following on your app DB will prevent this
alter Proc Batch_Mod_Rlsed @parm1 varchar ( 10), @parm2 varchar ( 2) as
Select * from Batch with (nolock)
where BatNbr = @parm1
and Module = @parm2
and Rlsed = 1
Also, check for custom triggers-SQL 2008 is very picky about the "Set Nocount On"
Thanks,
Karthik
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (