Query to put all databases in read only mode in SQL server

27 Aug, 2020

MSSQL SQL on Linux, SQL Server read only mode

select 'alter database [' + name + '] set READ_ONLY WITH NO_WAIT
go'
from sys.databases where database_id>4