Wednesday, October 17, 2012

How to rename the db




ALTER DATABASE [lab] SET SINGLE_USER  --SETTING TO SINGLEUSER
GO
sp_renamedb [lab] ,'LABs'  ---RENAMEDB
GO
ALTER DATABASE LABs SET MULTI_USER --AGAIN SETTING TO MULTIUSER

No comments: