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

0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *