SqlExecutionModes Enumeration

The SqlExecutionModes enumeration contains values that are used to specify whether the commands sent to the referenced connection to the server are executed immediately or saved in a buffer.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
<FlagsAttribute> _
Public Enumeration SqlExecutionModes
'Usage
Dim instance As SqlExecutionModes
[FlagsAttribute]
public enum SqlExecutionModes
[FlagsAttribute]
public enum class SqlExecutionModes
[<FlagsAttribute>]
type SqlExecutionModes
public enum SqlExecutionModes

Members

Member name Description
ExecuteSql Transact-SQL statements that are sent to the referenced connection to the server are forwarded to the server for immediate execution.
CaptureSql Transact-SQL statements that are sent to the referenced connection to the server are saved in a buffer.
ExecuteAndCaptureSql Transact-SQL statements that are sent to the referenced connection to the server are both saved in a buffer and forwarded to the server for immediate execution.

Remarks

The SqlExecutionModes enumeration class is served by the SqlExecutionModes property.