Configuration.CursorThreshold Property

Gets the ConfigProperty object that is used to set the cursor threshold configuration option.

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

Syntax

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

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

Property Value

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

Remarks

This property specifies the number of rows in the cursor set at which the cursor keysets are generated asynchronously.

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)