INF: Cannot Set Certain Database Options with SQL Enterprise Manager

ID: Q200353

The information in this article applies to:

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

Last Reviewed: January 19, 1999