What command do we use to rename a db?
Answers were Sorted based on User's Feedback
Answer / visala
sp_renamedb 'oldname','newname'
alter database <databasename>
modify name=<newdatabasename>
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / swetha
sp_renamedb ?oldname? , ?newname?
alter database ?databasename?
modify name = ?newdatabasename?
Is This Answer Correct ? | 7 Yes | 0 No |
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 |
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 |
What is openxml in sql server?
Explain throw statement in sql server 2008?
What is user stored procedure & it purpose?
please differentiate between delete and truncate?
Can you roll back the ddl statement in a trigger?
Do you know what is lock escalation?
What is the difference between set and select?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Explain what is use of dbcc commands?
How to insert data into an existing table?
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
What is the sql profiler?