Ads

14 February 2015

Unable to rename ' DBNAME'






ADDITIONAL INFORMATION:

Rename failed for Database 'XXXXXX'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+Database&LinkId=20476





Solution :

use master
GO

ALTER DATABASE SI SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE SI MODIFY NAME = [SI2]

ALTER DATABASE SI2 SET MULTI_USER






No comments:

Post a Comment