There are couple of options are available to rename the database.
Option 1 :
Rename the "MyDATABASE" to "MyDATABASE_NEW" using sp_renamedb command
EXEC sp_renamedb 'MyDATABASE', 'MyDATABASE_NEW'
Option 2:
Rename the "MyDATABASE" to "MyDATABASE_NEW" using ALTER DATABASE Commnad
USE [master]
GO
ALTER DATABASE [MyDATABASE] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [MyDATABASE] MODIFY NAME = MyDATABASE_NEW
GO
ALTER DATABASE [MyDATABASE_NEW] SET MULTI_USER
GO
No comments:
Post a Comment