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?
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
What is Federation and Federation Member?
What is side by side migration in sql server?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How to read data in a table with "select" statements?
Can we use where clause with group by?
What is #table in sql server?
If the job running very slow what is the action you do
Explain what is the difference between union and union all?
What happens if the update subquery returns no rows in ms sql server?
Describe how to use linked server?
What is primary key, unique key, and foreign key?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How do you run a trace?
What is difference between stored procedure and user defined function?
How to generate create function script on an existing function?