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, 2822👍, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know ex...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...