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, 3896🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...