ShowAdvancedOptions Property (SQL-DMO)

The ShowAdvancedOptions property controls ConfigValues collection membership.

Applies To

Syntax

object.ShowAdvancedOptions [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	True or False

Remarks

If True, advanced configuration options are included in the collection.

If False (default), advanced configuration options are not included.

Important Altering the value of ShowAdvancedOptions refills the ConfigValues collection. Any user alteration in configuration options performed before the ShowAdvancedOptions value change are applied by using the Transact-SQL RECONFIGURE WITH OVERRIDE statement.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetShowAdvancedOptions(LPBOOL pRetVal);

HRESULT SetShowAdvancedOptions(BOOL NewValue);