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.