ServerTraceEventSet.SpCacheinsert Property

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an item is inserted into the procedure cache.

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

Syntax

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

value = instance.SpCacheinsert

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether the SpCacheinsert 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