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
- 3980 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
Define constraints and give an example of their use?
What is read uncmmited?
Define full outer join in sql server joins?
How to populate a table in sql server?
Can you create a logon trigger in sql server 2005 express edition?
Does windows server 2016 come with sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
what's new in sql server 2016?
Is the log file is a part of file group?
What do you understand by check constraint in sql server?
Why truncate is ddl command?
Is it possible to have clustered index on separate drive from original table location?
How to loop through the result set with @@fetch_status?
Explain tables in SQL Azure?
What is BCNF? How is it better than 2NF & 3NF?
