Use this script to rename your db.
This one sets single user mod first so that there is exclusive access, then rename the db and bring back to normal mode (multi_user mode)
USE master;
GO
ALTER DATABASE [Old_DB_Name]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [Old_DB_Name]
MODIFY NAME= [New_DB_Name]
GO
ALTER DATABASE [New_DB_Name]
SET MULTI_USER WITH ROLLBACK IMMEDIATE
GO
Baljeetsingh Sucharia
Founder & Chief AI Strategist at Sucharia Strategic Solutions. Ex-Microsoft Software Architect who constructs custom AI workflows and bespoke software for growing businesses.