Collections:
READ_ONLY/READ_WRITE - Database Update Options in SQL Server
How to set database to be READ_ONLY in SQL Server?
✍: FYIcenter.com
Databases in SQL Server have two update options:
You can use the "ALTER DATABASE" to change database update options as shown in the tutorial below:
USE FyiCenterComData GO INSERT Links (Name) VALUES ('dba.FYIcenter.com') GO (1 rows affected) ALTER DATABASE FyiCentercomData SET READ_ONLY GO INSERT Links (Name) VALUES ('dev.FYIcenter.com') GO Msg 3906, Level 16, State 1, Server SQLEXPRESS, Line 1 Failed to update database "FyiCenterComData" because the database is read-only. SELECT * FROM Links GO Name dba.FYIcenter.com ALTER DATABASE FyiCentercomData SET READ_WRITE GO INSERT Links (Name) VALUES ('dev.FYIcenter.com') GO (1 rows affected)
As you can see from the output, inserting data into a table is not allowed if the database is in READ_ONLY mode.
⇒ SINGLE_USER/MULTI_USER - Database User Access Options in SQL Server
⇐ Moving Database Physical Files to New Locations in SQL Server
2016-11-20, 3277🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...