Compartir a través de


UserOptions.CursorCloseOnCommit Propiedad

Gets or sets the Boolean property value that specifies whether any open cursors are closed when a transaction is committed or rolled back.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy,  _
    "false")> _
Public Property CursorCloseOnCommit As Boolean 
    Get 
    Set
'Uso
Dim instance As UserOptions 
Dim value As Boolean 

value = instance.CursorCloseOnCommit

instance.CursorCloseOnCommit = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")]
public bool CursorCloseOnCommit { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy, 
    L"false")]
public:
property bool CursorCloseOnCommit {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")>]
member CursorCloseOnCommit : bool with get, set
function get CursorCloseOnCommit () : boolean 
function set CursorCloseOnCommit (value : boolean)

Valor de la propiedad

Tipo: System.Boolean
A Boolean value that specifies the whether any open cursors are closed when a transaction is committed or rolled back.If True, open cursors are closed when a transaction is committed or rolled back.If False (default), open cursors are not closed when a transaction is committed or rolled back.

Comentarios

This property overrides the CloseCursorsOnCommitEnabled property of the DatabaseOptions object setting.

Ejemplos

Configurar SQL Server en SMO

Vea también

Referencia

UserOptions Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

Configurar SQL Server en SMO

user options (opción)