PSS ID Number: Q200353
Article Last Modified on 10-27-2000
You can display and change database options by using either SQL Enterprise Manager or the sp_dboption stored procedure. It is easier to change database options with SQL Enterprise Manager, but sp_dboption provides more options than SQL Enterprise Manager.
We can compare there two utilities using the following table:
| Configurable Options | SQL Enterprise Manager | sp_dboption |
|---|---|---|
| ANSI null default | Yes | Yes |
| ANSI Nuls | No | Yes |
| ANSI Warnings | No | Yes |
| Auto create statistics | Yes | Yes |
| Auto update statistics | Yes | Yes |
| Autoclose | Yes | Yes |
| Autoshrink | Yes | Yes |
| concat null yields null | No | Yes |
| cursor close on commit | No | Yes |
| dbo use only | Yes | Yes |
| default to local cursor | No | Yes |
| merge publish | No | Yes |
| offline | No | Yes |
| published | No | Yes |
| quoted identifier | Yes | Yes |
| read only | Yes | Yes |
| recursive triggers | Yes | Yes |
| select into/bulkcopy | Yes | Yes |
| single user | Yes | Yes |
| subscribed | No | Yes |
| torn page detection | Yes | Yes |
| trunc. log on chkpt. | Yes | Yes |
sp_dboption 'sales', 'offline', 'TRUE'to take database 'sales' offline, but this option is not available in SQL Enterprise Manager.
Additional query words: sp_dboption db SEM ent man entman
Keywords: kbDSupport kbSQLServ2000
Issue Type: kbinfo
Technology: kbSQLServSearch kbAudDeveloper kbSQLServ700 kbSQLServ2000Search kbSQLServ2000