Rename SQL Server Database

Rename SQL Server Database:

Change the Database to Single User Mode and Rollback all the existing Transactions.
This is done because you need to obtain Exclusive Database Lock.
That way you don’t encounter errors related to obtaining database lock.
Rename the Database and then Turn on Multi User Accessibility.

Leave a Reply

Your email address will not be published. Required fields are marked *