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
- 4603 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
In This case you take following action
1. Alter DataBase <dbname> set single_user with rollback
immediate
2. Sp_renamedb 'olddb','newdb'
3. Alter DataBase <dbname> set multi_user
By
Kumar.T
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is field with example?
Explain about SQL server 2005?
What are functions in the sql server?
How to loop through result set objects using odbc_fetch_row()?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Mention what are the different types of ssrs reports?
What is a trace frag? Where do we use it?
What is bcp? When does it used?
Explain can SSRS reports Cache results?
What is a data collection table?
What is RAID? What are the different types of RAID configurations?
What are the disadvantages of using querystrings to send data from one page to another?
What is awe?
What is the difference between stored procedure and user defined functions?
Can we perform backup restore operation on tempdb? : sql server database administration
