Addressing Reserved Words Conflicts

use these techniques to address reserved word conflicts

• If any database names are reserved words, you must use sp_renamedb to change the database names before you can upgrade. Use sp_dboption to set the database to single-user mode, and then run sp_renamedb, specifying the new name. See the Reference Manual for more information on these procedures.
• If other identifiers are reserved words, you can use:
  • sp_rename to change the name of the object, before or after the upgrade.
  • Quoted identifiers.
  • Brackets around the identifier. For example:

    create table [table] ( [int] int, [another int] int )

• Run sp_checkreswords in master and in each user database to display the names and locations of conflicting identifiers. For more information about sp_rename and sp_checkreswords and methods for avoiding reserved word conflicts, see the Reference Manual.