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, 3326🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...