Specifies database options that you set when you created the database. For example, you must select the Single User option before you perform any database tests. You must clear this option when the tests are completed.
To open this window, on the File menu, choose Database, choose Alter, and then choose the Options tab.
Specifies that only one user can access the database at a time. You can use this setting when you are performing administrative functions such as testing or restoring the database. By limiting access to the database to one user, you make sure that the database is not changed when you are testing it.
Determines the kind of information that is written to the transaction log and therefore the kind of recovery model that you want to use in this database.
ANSI NULL default
Specifies whether the database default NULL settings for column definitions and user-defined data types are to be applied. When you select this option, all user-defined data types or columns that have not been explicitly defined as NOT NULL are set to allow NULL entries. Columns that have been defined by using constraints follow the constraint rules, regardless of this setting.
Specifies recursive trigger settings. Triggers can have direct recursion or indirect recursion. Direct recursion occurs when a trigger occurs and performs an action that causes the same trigger to be fired again. Indirect recursion occurs when a trigger occurs and performs an action that causes a trigger on another table to occur. This second trigger updates the original table which causes the first trigger to occur again.
Torn page detection
Enables SQL Server to detect incomplete input/output operations that have been caused by power failures or other system outages.
Specifies whether SQL Server can periodically shrink data files and transaction log files.