Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

II.2.1. Renaming a Database

After you have a database in place, renaming it is easy:

1. Launch the SQL Server Management Studio.

2. Connect to the appropriate SQL Server instance.

3. Expand the connection's entry in the Object Explorer view.

4. Expand the Databases folder.

5. Right-click the database name that you want to change and choose Rename.

6. Enter a new name for the database and press Enter.

Make sure to update any external objects that might reference this database by name, such as scripts, programs, stored procedures, and so on.