Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4723 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
Explain about thread and memory management process of SQL?
What is the dbcc command and why is it used?
How to create a login account in ms sql server to access the database engine using "create login" statements?
How to enter unicode character string literals in ms sql server?
In what sequence sql statement is processed?
What does it mean to normalize a database and why would you do it?
Explain security with sql azure?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Explain the benefits of user-defined functions?
Do you know what are various aggregate functions that are available?
What are sp_configure commands and set commands?
What is command parameter in ssrs?
What is a unique index?
Which sql server table is used to hold the stored procedure script?
What is user-defined scalar function?
