MS SQL Server Tips

* Renaming MS SQL Server 200 Database

1. Remove all the users connected to the database

  alter database <dbname> set single_user with rollback immediate

2. Run the below command to rename the database

  alter database <current_db_name> modify name=<new_db_name>

3. Set to multi user mode

  alter database <dbname> set multi_user