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?
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 the use of keyword with encryption.
How to enter comments in transact-sql statements?
What samples and sample databases are provided by microsoft?
Where do you find the default Index fill factor and how to change it?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Differentiate between sql temp table vs table variable?
What is difference between materialized view and view?
What is the difference between functions and stored procedures?
Can you pass expressions to stored procedure parameters?
Which is faster statement or preparedstatement?
List the different normalization forms?
Explain nested trigger in sql?
how will add additional conditions in sql?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is sleeping status in sql server?