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
- 4186 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
Can you explain what is the use of custom fields in report?
Define right outer join in sql server joins?
What is a schema in ms sql server 2005?
What are the essential components of sql server service broker?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How would you use user_constraints table in DB?
Introduction of rollup clause using sum and group by clause?
Do you know what are the steps to process a single select statement?
Is ssrs support other database except ms sql server?
What are the character string functions supported by sql server 2005?
Do comments need to go in a special place in sql server 2005?
How many tables can be joined in SQL Server?
Write a SQL command to insert and update only a particular field?
What are the different authentication modes in sql server? How can it be changed?
What does man by sql wildcard characters in sql server?
