Quoted Identifier Errors

Quoted identifiers are not the same as literals enclosed in double quotes. The latter do not require you to perform any special action before the upgrade.

dbcc upgrade_object returns a quoted identifier error if:

  • The compiled object was created in a pre-11.9.2 version with quoted identifiers active (set quoted identifiers on).

  • Quoted identifiers are not active (set quoted identifiers off) in the current session.

For compiled objects created in version 11.9.2 or later, the upgrade process automatically activates or deactivates quoted identifiers as appropriate.

  1. To avoid this error, activate quoted identifiers before running dbcc upgrade_object. When quoted identifiers are active, use single quotes instead of double quotes around quoted dbcc upgrade_object keywords.
  2. If quoted identifier errors occur, use the set command to activate quoted identifiers, and then run dbcc upgrade_object to upgrade the object.
Parent topic: Finding Compiled Object Errors Before Production