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.

To fix the error, either manually change the object name or use quotes around the object name, and issue the command set quoted identifiers on. Then, drop and re-create the compiled object.

For example, suppose you load a database dump from an older verion of SAP ASE into a current version, and the dump contains a stored procedure that uses the word “XYZ,” which is a reservered word in the current version. When you run dbcc upgrade_object on that stored procedure, the command returns an error because, although “XYZ” was not reserved in the older version, it became a reserved word in the current version. With this advance notice, you can change the stored procedure and any related tables before they are used in a production environment.