• Article

IDatabaseOptions.LocalCursorsDefault Property

Gets the Boolean value that specifies whether the local server cursors are used by default.

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

Syntax

'Declaration
<DisplayDescriptionKeyAttribute("Database_LocalCursorsDefaultDesc")> _
<DisplayNameKeyAttribute("Database_LocalCursorsDefaultName")> _
Property LocalCursorsDefault As Boolean
    Get
    Set
'Usage
Dim instance As IDatabaseOptions
Dim value As Boolean

value = instance.LocalCursorsDefault

instance.LocalCursorsDefault = value

[DisplayDescriptionKeyAttribute("Database_LocalCursorsDefaultDesc")]
[DisplayNameKeyAttribute("Database_LocalCursorsDefaultName")]
bool LocalCursorsDefault { get; set; }

[DisplayDescriptionKeyAttribute(L"Database_LocalCursorsDefaultDesc")]
[DisplayNameKeyAttribute(L"Database_LocalCursorsDefaultName")]
property bool LocalCursorsDefault {
    bool get ();
    void set (bool value);
}

[<DisplayDescriptionKeyAttribute("Database_LocalCursorsDefaultDesc")>]
[<DisplayNameKeyAttribute("Database_LocalCursorsDefaultName")>]
abstract LocalCursorsDefault : bool with get, set

function get LocalCursorsDefault () : boolean
function set LocalCursorsDefault (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether local cursors are used by default.
If True, local cursors are used.
If False (default), local cursors are not used and the cursors are implemented at the client.