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
- 4621 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 to find which stored procedure is currently running in sql server?
Name few of the dcl commands in sql?
Explain a checkpoint?
How to fetch the next row from a cursor with a "fetch" statement?
Where cross join is used?
What is the use of custom fields in report?
How to receive returning result from a query?
What is row-level compre?
how we use window authentication connection with sql server.?
can you instantiate a com object by using t-sql? : Sql server database administration
Can you force a query to use a specific index?
What is user defined datatypes and when you should go for them?
which table keeps the locking information? : Sql server administration
What is user-defined scalar function?
Explain user defined views?
