How to change database from Read-Only to Read-Write mode in SQL SERVER ?
Recently, I was working on new ASP.NET application and for that I attach an existing database to SQL SERVER. I noticed that it gets attached in read-only mode.
So, to change database to Read-Write mode, I need to follow any of the below steps:
A. Using SQL SERVER Management Studio:
Right click on Database, select Properties. And in the Database Properties window, select Options page. In Options page, under State change Database Read Only value to False.
B. Using SQL query:
ALTER DATABASE [TechCartNow] SET READ_WRITE