November 22, 2016

You can use the following query to rename an SQL Database: USE masterGOALTER DATABASE YOURDATABASENAME SET SINGLE_USER WITH ROLLBACK IMMEDIATEGOEXEC master..sp_renamedb ‘YOURDATABASENAME’,’YOUR_NEW_DATABASE_NAME’GOALTER DATABASE YOUR_NEW_DATABASE_NAME SET MULTI_USER GO The only problem,