Export (0) Print
Expand All

show advanced options Option

SQL Server 2000

Use the show advanced options option to display the sp_configure system stored procedure advanced options. When you set show advanced options to 1, you can list the advanced options by using sp_configure. The default is 0.

The setting takes effect immediately (without a server stop and restart).

To set the show advanced options option

Transact-SQL

SQL-DMO

See Also

RECONFIGURE

Setting Configuration Options

sp_configure

Show:
© 2014 Microsoft