Addressing Reserved Words Conflicts

Change any database names that are reserved words.

  1. Use sp_dboption to set the database to single-user mode, then run sp_renamedb, specifying the new name.
  2. 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 )
  3. Run sp_checkreswords in master and in each user database to display the names and locations of conflicting identifiers.
    See Reference Manual: Procedures for information about sp_dboption, sp_rename, and sp_checkreswords.