Monday, December 12, 2011

Rename Database Name in MS SSL Server

Use the below script to Rename Database
ALTER DATABASE [old_name]
 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [old_name]
 MODIFY NAME = [new_name]
GO
ALTER DATABASE [new_name]
 SET MULTI_USER
GO

No comments:

Post a Comment