Quoted identifier errors

dbcc upgrade_object returns a quoted identifier error if:

To avoid this error, activate quoted identifiers before running dbcc upgrade_object. When quoted identifiers are active, you must use single quotes instead of double quotes around quoted dbcc upgrade_object keywords.

If quoted identifier errors occur, use the set command to activate quoted identifiers, and then run dbcc upgrade_object to upgrade the object.

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

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