Hi Friends
What command do we use to rename a db ?
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.
Chetan KumarPosted Oct 22, 2012, 7:52 AM
Sp_renamedb 'olddbname','newdbname'
Satyapriya NayakPosted Sep 26, 2012, 7:18 AM
nallyaPosted Sep 26, 2012, 7:15 AM
1) issues these commands
2) detach the database
3) rename the files on disk
4) re-attach the database again
Use this
http://www.sourcecodester.com/tutorials/3759/how-rename-sql-server-database-and-database-filename-mdf-file.html
http://dbalink.wordpress.com/2008/07/10/how-to-rename-sql-server-2005-database-using-tsql/
Pradip PandeyPosted Sep 26, 2012, 7:12 AM
Check this link
http://msdn.microsoft.com/en-us/library/aa238879(v=sql.80).aspx
http://www.mssqltips.com/sqlservertip/1122/how-to-rename-a-sql-server-database/
Hope it will help.