Skip to main content

Set SQL Server Database property Read/Write, Read-Only

“When I tried to attach the sql server database file .mdf on client's machine.After attachment the database status is showing (Read-Only) (Eg.database name (Read-Only). It will allow to retrieve(select) the values from tables, etc. but won't allow to Insert, Update & Delete operations.

To make this read-only database to read-write, just execute the following query.

Make Database Read Only

USE [master]
GOALTER DATABASE [TESTDB] SET READ_ONLY WITH NO_WAIT
GO

Make Database Read/Write

USE [master]
GOALTER DATABASE [TESTDB] SET READ_WRITE WITH NO_WAIT
GO

I hope this post will help you.
Regards,
Gajanan

Comments

Post a Comment

Popular posts from this blog

Creating package in Oracle Database using Toad For Oracle

What are Packages in Oracle Database A package is  a group   of procedures, functions,  variables   and  SQL statements   created as a single unit. It is used to store together related objects. A package has two parts, Package  Specification  and Package Body.
Read more

Resolving 'Setup Account Privileges' error while installing SQL Server

A new installation of Microsoft SQL Server 2012 or Microsoft SQL Server 2008 R2 fails You see the following error message when you try to install a new instance of SQL Server 2012 or SQL Server 2008 R2: Rule "Setup account privileges" failed.
Read more

Creating Oracle stored Procedures using TOAD for Oracle

In a database management system, a  stored procedure  is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of  stored procedures  can be helpful in controlling  access to data, preserving  data integrity  and  improving  productivity.
Read more