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
- 4739 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 page splits? : SQL Server Architecture
Write down the syntax and an example for create, rename and delete index?
What is report server project?
Explain full-text indexing?
How to create user defined functions with parameters?
What are the purposes and advantages stored procedure?
Do you know data definition language, data control language and data manipulation language?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is difference between delete and truncate commands?
How to Check if table exists in sql server?
How to delete a database in ms sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How do I view a trc file?
What is a raid and what are different types of raid configurations?
Difference between uniqe index and uniqe constraint?
