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.

database read only

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.

sql server database read only

B. Using SQL query:


database read write



Kapil Khandelwal

Web Developer, Blogger, Microsoft Certified Professional (MCP), DZone's Most Valuable Blogger (MVB)

You may also like...

1 Response

  1. Ruchi says:



Leave a Reply

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