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