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
- 4815 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 create a stored procedure with a statement block in ms sql server?
What are synonyms?
Explain about nested stored procedure?
What is the maximum row of a size?
How can I change procedure name in sql server?
How to find tables without indexes?
What is the difference between index seek vs. Index scan?
how to take backup bcp out for a column in table in sql server?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is the cartesian product of table?
What is data compression?
What are different replication agents and what's their purpose? : sql server replication
What is the language structure to add a record to a table?
Explain subquery and state its properties?
How to use transact-sql statements to access the database engine?
