Mega Code Archive

 

Categories / MSSQL Tutorial / Database

 

How to set a databases updatability value to READ_ONLY and how to determine the updatability of a database

ALTER DATABASE pubs SET READ_ONLY SELECT DATABASEPROPERTYEX('pubs', 'updateability')