ServerTraceEventSet.ExchangeSpillEvent Property

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when communication buffers in a parallel query plan have been temporarily written to the tempdb database.

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

Syntax

'Declaration
Public Property ExchangeSpillEvent As Boolean 
    Get 
    Set
'Usage
Dim instance As ServerTraceEventSet 
Dim value As Boolean 

value = instance.ExchangeSpillEvent

instance.ExchangeSpillEvent = value
public bool ExchangeSpillEvent { get; set; }
public:
property bool ExchangeSpillEvent {
    bool get ();
    void set (bool value);
}
member ExchangeSpillEvent : bool with get, set
function get ExchangeSpillEvent () : boolean 
function set ExchangeSpillEvent (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the ExchangeSpillEvent event is included in the event set.If True, the event is included in the event set.If False (default), the event is not included in the event set.

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Examples

Handling SMO Events

See Also

Reference

ServerTraceEventSet Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tracing and Replaying Events

SQL Server Event Class Reference