-- Ensure that it is SSMS connecting to the database
EXEC sp_who2

ALTER DATABASE mydb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE mydb MODIFY NAME = mynewname;
ALTER DATABASE mynewname SET MULTI_USER WITH ROLLBACK IMMEDIATE;