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)
------------------------------
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