Propriété UserOptions.CursorCloseOnCommit
Gets or sets the Boolean property value that specifies whether any open cursors are closed when a transaction is committed or rolled back.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy, _
"false")> _
Public Property CursorCloseOnCommit As Boolean
Get
Set
'Utilisation
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)
Valeur de propriété
Type : 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.
Notes
This property overrides the CloseCursorsOnCommitEnabled property of the DatabaseOptions object setting.
Exemples
Configuration de SQL Server dans SMO
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo