Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases?
- 2 Answers
- 3979 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
In This case you take following action
1. Alter DataBase <dbname> set single_user with rollback
immediate
2. Sp_renamedb 'olddb','newdb'
3. Alter DataBase <dbname> set multi_user
By
Kumar.T
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between commit and rollback?
what is the difference between delete table and truncate table commands? : Sql server database administration
How to execute stored procedure in select statement sql server?
How to use copy and concatenate commands in SQL?
How to store and query spatial data?
Define tool Manage Statistics in SQL Server 2000 query ?
How to get a list of all tables with "sys.tables" view in ms sql server?
Do you know what are the reporting services components?
What does null mean?
What are examples of triggers?
What is standby servers? Explain types of standby servers.
What is the maximum size per database for sql server express?
Where are stored procedures in sql server?
List the different types of joins?
How many replicas are maintained for each sql azure db?
