Rename DB Name
USE master
GO
ALTER DATABASE current_DBName
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO
EXEC master..sp_renamedb 'current_DBName','New_DBName'
GO
ALTER DATABASE New_DBName
SET MULTI_USER
Rename DB Filenames:
/* Set Database as a Single User */
ALTER DATABASE current_DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
/* Change Logical File Name */
ALTER DATABASE [current_DBName] MODIFY FILE (NAME=N'current_DBName', NEWNAME=N'New_DBName')
GO
ALTER DATABASE [current_DBName] MODIFY FILE (NAME=N'current_DBName_log', NEWNAME=N'New_DBName_log')
GO
