Wednesday, December 9, 2015

Rename database

ALTER DATABASE AssetMgmtServices SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE AssetMgmtServices
MODIFY NAME = AssetMgmtServices_Nov2012
GO

ALTER DATABASE AssetMgmtServices_Nov2012
SET MULTI_USER
GO

No comments:

Post a Comment