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
- 4184 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
In what sequence sql statement is processed?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is the difference between primary key and unique constraints?
How to find the list of fixed hard drive and free space on server?
What is the Difference Between Primary and Foreign Key?
How to create new tables with "create table" statements in ms sql server?
How raid can influence database performance?
What is the parse query button used for?
How adventureworkslt tables are related?
What do you mean by an execution plan? How would you view it?
What are system databases into sql server (2005/2008)?
What are the different types of Indexes available in SQL Server?
Write a SQL query to make a column as unique?
How you can get a list of all the table constraints in a database?
What do mean by xml datatype?
