Finding compiled object errors before production

Changes made in versions of Adaptive Server earlier than 12.5.x may cause compiled objects to work differently once you upgrade to a later version. You can use dbcc upgrade_object to find the following errors and potential problem areas that may require manual changes to achieve the correct behavior:

After reviewing the errors and potential problem areas, and fixing those that need to be changed, use dbcc upgrade_object to upgrade compiled objects manually instead of waiting for the server to upgrade the objects automatically. See the Reference Manual: Commands.