System Message 6900, 6906 or SQL Server messsage 62, 63, 67 or 93 when you save or release a batch in Microsoft Dynamics SL 2011

Symptoms

When you save or release a batch in various modules in Microsoft Dynamics SL 2011, you may receive one or more of the following error messages:

System Message 6900 - Another process has updated the %s table. The system will automatically cancel your changes.

System Message 6906 - Another process has deleted the %s item. The system will automatically cancel your changes.

SQL Server Message 93 - [Microsoft][SQL Server Native Client 10.0] Connection is busy with results for another command.

SQL Server Message 62 - [Microsoft][SQL Server Native Client 10.0] Invalid Cursor State.

SQL Server Message 63 - [Microsoft][SQL Server Native Client 10.0]Query timeout expired.

SQL Server message 67 - Invalid transaction state.


Cause

This problem occurs if the Microsoft Dynamics SL Application database contains SQL triggers.  

Resolution

To correct this issue, add the following line of code to the beginning of any SQL triggers or of any stored procedures that you apply to the database.

set nocount on

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×