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, 3323🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...