change Databasename
How to Change DataBase Name in sql server 2008 r2
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
RobbinsonPosted May 30, 2014, 3:42 AM
You can rename database using below T-SQL script.
USE master;
GO
ALTER DATABASE MyDB1
Modify Name = MyDBRename ;
You can also do the same using SQL Server Management Studio tool.
1.In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2.Make sure that no one is using the database, and then set the database to single-user mode.
3.Expand Databases, right-click the database to rename, and then click Rename.
4.Enter the new database name, and then click OK.
Hope, this will help you out. Please don't forget to mark as answer if this post helps you.
Ranjit PowarPosted May 30, 2014, 3:39 AM
2. Expand Databases ,right click the database to rename , and then click Rename.
3.Enter the new database name click Ok.