Addressing Reserved Words Conflicts

Use sp_dboption to set the database to single-user mode, and then run sp_renamedb, specifying the new name.

1. If other identifiers are reserved words, 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 )

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