DBOption Object Properties Methods Collections
| Property | Description |
|---|
| ColumnsNullByDefault Boolean Write: Yes |
Determines if columns in newly created tables allow nulls by default. If True, columns will allow null values unless they are explicitly defined as not allowing null values (NOT NULL). If False, columns will not allow null values unless they are explicitly defined as allowing null values. |
| DBOUseOnly Boolean Write: Yes |
Determines if only the database owner can use the database. If True, only the database owner can use the database. If False, every user can use the database. |
| EnablePublishing Boolean Write: Yes |
Determines if articles can be published for replication in this database. If True, articles can be published and replication from this database is enabled. If False, this database cannot publish articles for replication. |
| EnableSubscribing Boolean Write: Yes |
Determines if published articles can be subscribed to by this database. If True, articles can be subscribed to and replication to this database is enabled. If False, this database cannot subscribe to articles for replication. |
| NoCheckpointOnRecovery Boolean Write: Yes |
Determines if an up-to-date copy of a database is kept. If True, an up-to-date copy of the database is kept. If False, a checkpoint record is added to a database after it is recovered due to restarting SQL Server. |
| Offline Boolean Write: Yes |
Determines if the database if offline and unavailable for use. If True, the database is unavailable. If False, the database is online and available for use as normal. |
| Parent Database Write: No |
The Database object. |
| ReadOnly Boolean Write: Yes |
Determines if all changes to the database are disabled. If True, the database is read only and cannot be changed. If False, the data can be changed as normal. |
| SelectIntoBulkCopy Boolean Write: Yes |
Determines if the following unlogged operations are allowed in the database: WRITETEXT, SELECT INTO into a permanent table, and fast bulk copy into a table with no indexes. If True, unlogged operations are allowed and you can use the above statements. If False, unlogged operations are not allowed. |
| SingleUser Boolean Write: Yes |
Determines if only one user at a time can use the database. If True, the database is in single user mode. If False, multiple users can access the database as normal. |
| TruncateLogOnCheckpoint Boolean Write: Yes |
Determines if the transaction log is truncated (committed transactions are removed) every time the automatic CHECKPOINT checking process occurs. If True, the transaction log is truncated automatically on CHECKPOINT. If False, the transaction log is not truncated automatically. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |