Share via


Configuration.UserOptions Property

Gets the ConfigProperty object that is used to set the user options configuration option.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public ReadOnly Property UserOptions As ConfigProperty 
    Get
'Usage
Dim instance As Configuration 
Dim value As ConfigProperty 

value = instance.UserOptions
public ConfigProperty UserOptions { get; }
public:
property ConfigProperty^ UserOptions {
    ConfigProperty^ get ();
}
member UserOptions : ConfigProperty
function get UserOptions () : ConfigProperty

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the user options configuration option.

Remarks

This property specifies the global defaults for all users. A list of default query processing options is established for the duration of a user's work session. This property lets you change the default values of the SET statement options. A user can override these defaults by using the SET statement.

Examples

Configuring SQL Server in SMO

See Also

Reference

Configuration Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options (SQL Server)

sp_configure (Transact-SQL)