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
- 4700 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
In such cases we can first bring to db to single user using
sp_dboptions and then we can rename that db and then we can
rerun the sp_dboptions command to remove the single user mode.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how you can configure a running aggregate in SSRS?
What are differences in between sql server 2012 and sql server 2016?
Explain the truncate command? : SQL Server Architecture
Give an example of why you would want to denormalize a database
what's the difference between a primary key and a unique key? : Sql server database administration
How to create new table with "create table" statements?
What is the use of commit?
What are synonyms?
Which sql server table is used to hold the stored procedure scripts?
List out the differences between the clustered index and non-clustered index in sql server?
Can you explain various data region available in ssrs with their use?
What is the purpose of a table?
Ways to improve the performance of a SQL Azure Database?
Can a table have 2 foreign keys?
Do you know how to make remote connection in database?
