Database SQL Server

Changing a SQL database name

 
USE master;
alter database DB1_DEV set SINGLE_USER with rollback immediate
go

ALTER DATABASE DB1_DEV
Modify Name = DB1;
GO


 
 
alter database DB1 set MULTI_USER
go