MSSQL%20Interview%20Questions%20and%20Answers
Question: Why I am getting this error when renaming a database in MS SQL Server?Answer: If you are trying to rename a database that is in use, you will get an error message like this: "The database could not be exclusively locked to perform the operation."Before renaming a database, you must stop all client sessions using this database. Otherwise, you will get an error as shown in this tutorial example: 1. Launch one instance of SQL Server Management Studio and run: USE withoutbook GO 2. Keep the first instance running and launch another instance of SQL Server Management Studio: ALTER DATABASE withoutbook MODIFY NAME = withoutbookdb GO Msg 5030, Level 16, State 2, Server LOCALHOSTSQLEXPRESS The database could not be exclusively locked to perform the operation. Obviously, the first instance is blocking the "ALTER DATABASE" statement. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft SQL Server?
- What is the simplest way to create a new database in MS SQL Server?
- How to delete a database in MS SQL Server?
- How to download and install Microsoft .NET Framework Version 2.0?
- How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?