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
- 4635 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 difference between group by and having?
What are different types of data sources?
What is the function of sql server agent windows service?
How you can change the database name in SQL SERVER?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is sql server schema compare? How we can compare two database schemas?
Why would you call update statistics?
What is change tracking in sql server?
What are the two modes of authentication in sql server?
What are the disadvantages of merge replication?
What is query cost in sql server?
How to count groups returned with the group by clause in ms sql server?
What is always encrypted?
What is table value parameters (tvp)?
Can you always create a cache of a report?
