Database.LocalCursorsDefault Property

Gets or sets a 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
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property LocalCursorsDefault As Boolean 
    Get 
    Set
'Usage
Dim instance As Database 
Dim value As Boolean 

value = instance.LocalCursorsDefault

instance.LocalCursorsDefault = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool LocalCursorsDefault { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
virtual property bool LocalCursorsDefault {
    bool get () sealed;
    void set (bool value) sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
abstract LocalCursorsDefault : bool with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
override LocalCursorsDefault : bool with get, set
final function get LocalCursorsDefault () : boolean 
final 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.

Implements

IDatabaseOptions.LocalCursorsDefault

See Also

Reference

Database Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scope of Transact-SQL Cursor Names