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
- 4608 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
What are pages and extents? : SQL Server Architecture
How to check table values in sql server?
Explain different backup plans?
What command must you use to include the not null constraint after a table has already been created?
Explain the properties of a relational table?
How to find related tables in sql server?
What is the difference between varchar and nvarchar datatypes?
Can two tables have the same primary key?
How to delete database objects with "drop" statements in ms sql server?
what authentication modes does sql server support? : Sql server database administration
What is ssrs?
What is linked report?
What is meant by Active-Passive and Active-Active clustering setup?
What action plan is preferred if sql server is not responding?
What is partition in sql server?
