Change Database Name in SQL Server

SQL Server Enterprise Manager does not let you change your database name once you create it. If you want to change your database name, you may have to manually run the following script to change it. First of all you have to login to SQL Server using osql command line utility. Once you are in, fire following commands to rename database.

ALTER DATABASE OldName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
 
sp_renamedb 'OldName', 'NewName'
GO
 
ALTER DATABASE NewName SET MULTI_USER
GO

Share

1 comment

Your email address will not be published. Required fields are marked *

  1. Pablo Alonso says:

    Hi, what if I need to chance the database file name also?

    I can’t find how to duplicate a database…. if you can help me please write me at pablo.alonso@itsas.com.ar

    thank you very much

    regards,
    Pablo