DBOption Object (SQL-DMO)

The DBOption object represents the settings for Microsoft® SQL Server™ database options for a specific SQL Server database.

Remarks

SQL Server database options control access to and behaviors for a specific SQL Server database. You can use the DBOption object to set the values for SQL Server database options.

To set a SQL Server database option

1. Get the DBOption object from a Database object of a connected SQLServer object.
2. Set the desired property to reflect the change you want in behavior. For example, set the value of the ReadOnly property to TRUE to enable read-only access to the database.

Changes to DBOption properties are reflected in the SQL Server database as they are made.

Methods

Refresh Method

Properties