New Post has been published on Varinder Sandhu 's Blog
New Post has been published on http://www.varindersandhu.in/2011/05/22/sql-server-database-read-only/
SQL Server - Database Read Only
Here is simple script with you can set your database in Read-Only Mode
Once you specify database is in read-only mode then users can read data from the database, not modify it.
Here is Script :
Mark Database Read Only
USE [master] GO ALTER DATABASE database_name SET READ_ONLY WITH NO_WAIT
Similarly you can change database Read-Only Mode to Read-Write
Here is script :
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
Mark Data Read- Write Mode
USE [master] GO ALTER DATABASE database_name SET READ_WRITE WITH NO_WAIT GO
Alternative way
1. Click the Start button.
2. Select All Programs.
3. Navigate to the Microsoft SQL Server 2008 folder.
4. Right Click on database then click properties
5. In the Option under State drop down
6. Mark Database Read-Only – True
7. Click OK.