Finding Compiled Object Errors Before Production

Changes made in earlier versions of Adaptive Server may cause compiled objects to work differently in version 12.5.x and later.

• Reserved Word Errors
  If dbcc upgrade_object finds a reserved word used as an object name in a compiled object, it returns an error, and that object is not upgraded.
• Missing, Truncated, or Corrupted Source Text
  If the source text in syscomments was deleted, truncated, or otherwise corrupted, dbcc upgrade_object may report syntax errors.
• Quoted Identifier Errors
  Learn about quoted identifier errors.
• Temporary Table References
  If a compiled object such as a stored procedure or trigger refers to a temporary table (#temp table_name) that was created outside the body of the object, the upgrade fails, and dbcc upgrade_object returns an error.
• select * Potential Problem Areas
  In Adaptive Server version 11.9.3 and later, the results of a select * clause in a stored procedure, trigger, or view that was created in an earlier version of Adaptive Server may be different from what you expect.
• Determining Whether select * Should Be Changed in Views
  If dbcc upgrade_object reports the existence of select * in a view, compare the output of syscolumns for the original view to the output of the table, to determine whether columns have been added to or deleted from the table since the view was created.