INF: Cannot Set Certain Database Options with SQL Enterprise Manager
ID: Q200353
|
The information in this article applies to:
-
Microsoft SQL Server version 7.0
SUMMARY
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 |
For example, you can run
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 : SSrvEntMan SSrvSQL_Admin SSrvTran_SQL
Version : winnt:7.0
Platform : winnt
Issue type : kbinfo