Skip to content
logo Knowledgebase

Sage 200 - Index of useful SQL scripts

Created on  | Last modified on 


As well as our telephone support for the Sage 200 Suite, you can take advantage of a vast database of articles designed to assist you with resolving any queries or issues for your own software. Below is an index of commonly used Ask Sage articles for useful SQL scripts. We recommend you bookmark this article for future reference.


To access Ask Sage, visit

NOTE: The list is not necessarily exhaustive and for up to the minute information regarding the software, a direct search of Ask Sage is recommended.

NOTE: This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.





SQL Scripts
Article name
Can I compare the difference between two databases in SQL >>
Sage 200 - Error "unexpected exception contract failure: a referential integrity on update has occurred. This method should be overridden by the subclass" >>
Sage 200 - Error when attempting to access the Menu editor >>
Sage 200 - Accrual posting amount differs >>
Sage 200 Manufacturing - SQL script to remove duplicate entries from list views >>
Sage 200 Professional - SQL script to check if the database contains any triggers >>
Sage 200 Professional - SQL script to find a specific column in the database >>
Sage 200 Professional - SQL script to find a particular key word within the database >>
Sage 200 Professional - SQL script to find database ID >>
Find Quantity Reserved value for all relevant SQL database tables >>
Sage 200 Professional - How to sync Manufacturing stock tables >>


Sage 200 Services

Did you know Sage 200 customers now have access to a range of services direct with Sage. These include a bespoke Report Design Service, a library of How to Webinars and Ideas Hub just to name a few. Explore your potential using Sage 200 Services.



Simple, automated and all in one place
Manage your employees’ taxable benefits easily and accurately, with online submissions to HMRC. Deadline for P11D submission is July 6 2022.

Find out more