Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What command do we use to rename a db?

Answers were Sorted based on User's Feedback



What command do we use to rename a db?..

Answer / visala

sp_renamedb 'oldname','newname'

alter database <databasename>
modify name=<newdatabasename>

Is This Answer Correct ?    17 Yes 0 No

What command do we use to rename a db?..

Answer / swetha

sp_renamedb ?oldname? , ?newname?

alter database ?databasename?
modify name = ?newdatabasename?

Is This Answer Correct ?    7 Yes 0 No

What command do we use to rename a db?..

Answer / latha sree

sp_renamedb ?oldname? , ?newname?

Is This Answer Correct ?    7 Yes 1 No

What command do we use to rename a db?..

Answer / karthick.r

sp_rename olddatabasename newdatabasename
for eg
sp_rename prodetails empdetails;


in this eg the name of the prodetails is changed into
empdetails using above command

Is This Answer Correct ?    2 Yes 1 No

What command do we use to rename a db?..

Answer / babuli

To rename a SQL database follow the these seps:

1. Alter database to single user mode. So that all the
active connection will be terminated. (Database properties
-> options > single usermode)
2. Then rename the database using sp_renamedb oldname, newname

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the dbcc command and why is it used?

0 Answers  


Explain what is use of dbcc commands?

0 Answers  


What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  


What is user-defined multi-statement table-valued function?

0 Answers  


Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,


How to start and end transact-sql statements?

0 Answers  


Tell me about builtinadministrator?

0 Answers  


what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  


Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  


how to select a field with firstletter as capital and remaining are small letters

11 Answers  


How many instances per computer are there in sql server 2000?

0 Answers  


Categories