Thursday, 19 September 2013

Error occurred when changing the database name

Error occurred when changing the database name

I needed to change my database name so i executed this query
So first i just right clicked on the database and selected the option Rename
It showed a dialogue box as
TITLE: Microsoft SQL Server Management Studio
Unable to rename Faculty. (ObjectExplorer)



ADDITIONAL INFORMATION:
Rename failed for Database 'Project'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+Database&LinkId=20476



An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)



Database 'Project' is in transition. Try the statement later. (Microsoft
SQL Server, Error: 952)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=952&LinkId=20476



BUTTONS:
OK
Then i executed this query ALTER DATABASE [Project] MODIFY NAME = [Faculty]
But its giving an error as Msg 952, Level 16, State 1, Line 1 Database
'Project' is in transition. Try the statement later.
Is there any other ways that i can change my name.?

No comments:

Post a Comment