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
- 4816 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
Which are the new data types introduced in sql server 2008?
what is a transaction and what are acid properties? : Sql server database administration
How do I start and stop sql server?
How to send a ssrs report from ssis?
Define full outer join in sql server joins?
How do you make a trace?
How to select an exiting database using mssql_select_db()?
What the class forname () does?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
how can you check the level of fragmentation on a table? : Sql server administration
What command is used to rename the database?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Can you explain different types of locks in sql server?
How to stop log file growing too big?
What is meant by dirty read?
