All users with access to the master database can execute sp_dboption with no parameters to display a list of the database options. The report from sp_dboption looks like this:
sp_dboption
Settable database options. -------------------- abort tran on log full allow nulls by default allow wide dol rows async log service auto identity dbo use only ddl in tran delayed commit enforce dump tran sequence full logging for all full logging for alter table full logging for reorg rebuild full logging for select into identity in nonunique index no chkpt on recovery no free space acctg read only select into/bulkcopy/pllsort single user trunc log on chkpt trunc. log on chkpt. unique auto_identity index
For a report on which options have been set in a particular database, execute sp_helpdb in that database.
See the Commands Reference: Procedures for information about each database option in detail.
