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

Asp.Net Web API

What is ASP.NET Web API? ASP.NET Web API is a framework provided by the Microsoft with which we can easily build HTTP services that can reach a broad of clients, including browsers, mobile, IoT devices, etc. ASP.NET Web API provides an ideal platform for building RESTful applications on the .NET Framework.   Difference between ASP.NET Web API and WCF Web AP I is a Framework to build HTTP Services that can reach a board of clients, including browsers, mobile, IoT Devices, etc. and provided an ideal platform for building RESTful applications. It is limited to HTTP based services. ASP.NET framework ships out with the .NET framework and is Open Source. WCF i.e. Windows Communication Foundation is a framework used for building Service Oriented applications (SOA) and supports multiple transport protocol like HTTP, TCP, MSMQ, etc. It supports multiple protocols like HTTP, TCP, Named Pipes, MSMQ, etc. WCF ships out with the .NET Framework. Both Web API and WCF can be self-hosted or can be...
Read more

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