Category: SQL Server
view more software Tips and Tricks
Updated: 10/17/2011 06:10 AM
Author: Shiju Mathews
When are working with databases we need to change the database mode between to Read/Write to Read-Only mode or vice versa for different operation.
Usually this is happen when we are trying to attach database back up created by users. Or we need to change database mode to Read-Only when we are not updating the database.
The following script can be change the Modes.
“CourtesyIndiaDB” is my database that I need to change the modes. I used SQL Server 2008
Make Database Read-Only Mode
To Make Database Read/Write Mode