usp_ToggleDatabases

usp_ToggleDatabases is a simple procedure that will switch the names of two databases.

One of the main problems with using sp_renamedb to switch databases is that the procedure will wait until the database is free before the rename can be completed. If the new live database is also in use then there is a likelyhood that the renaming of the current database could be successful and the second database will fail.

The procedure attached will wait until all databases are free before trying to switch them around.

A total of 5 sets of databases can be passed to this procedure and it will not start switching any database unless all have noone accessing any of them at a given point.