Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
How is table type constraint applied to a table?
What is measure group, measure? : sql server analysis services, ssas
How do you manipulate data?
How to truncate the log in sql server 2012? : sql server database administration
What are the advantages to use stored procedures?
Explain sql delete command?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is sql language?
What is coalesce in sql server?
What is difference between inner join and join?
What security features are available for stored procedure?
What is trigger and different types of Triggers?
What is mapping schema?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Can we deploy SSRS reports on our personal website?
