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?
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
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
