How to rename a database in SQLserver?

 Posted by Nishithraj on 1/5/2010 | Category: Sql Server Interview questions | Views: 2027
Answer:

using the procedure sp_renamedb. Following is the syntax

Exec sp_renamedb ‘olddbname’,’newdbname’


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response