Home Forums SQL Server 2005 Administering Changing Database In Single User Mode To Multi User RE: Changing Database In Single User Mode To Multi User

  • Mohammed,

    Ok, I actually got it to go into multi user mode by going to Services and restarting the SQL Server and then giving it the

             Alter database RB_Data_Services_MSCRM

             Set multi_user;

    command and then it took it.

    I then wanted to rename it and so from the Management Studio I highlighted that db and then right clicked and selected rename.  I gave it another name and then when I hit the enter key I got:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Unable to rename RB_Data_Services_MSCRM22. (ObjectExplorer)

    ------------------------------

    ADDITIONAL INFORMATION:

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

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&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)

    ------------------------------

    The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)

    ****************************************

    So how do I exclusively lock this data base so I can then rename or delete it?

    Thanks.

     

    Rick Bellefond