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:

For compiled objects the upgrade process automatically activates or deactivates quoted identifiers as appropriate.

  1. 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.