Dinesh Beniwal
What command do we use to rename a db?
By Dinesh Beniwal in SQL Server on Jul 13 2006
  • Manju lata Yadav
    Jul, 2014 1

    USE master; GO ALTER DATABASE AdventureWorks2012 Modify Name = Northwind ; GOsp_renamedb [ @dbname = ] 'old_name' , [ @newname = ] 'new_name' is second option But Avoid it bcz This feature will be removed in a future version of Microsoft SQL Server. Use ALTER DATABASE MODIFY NAME instead.

    • 0
  • Dinesh Beniwal
    Jul, 2006 13

    sp_renamedb ‘oldname’ , ‘newname’

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS