TableEvents TableEvents TableEvents Class

Definition

The TableEvents object represents the settings required for SQL Server table event notification.

public ref class TableEvents
public class TableEvents
Public Class TableEvents
Inheritance
TableEventsTableEventsTableEvents

Examples

Handling SMO Events

Remarks

The TableEvents class is accessed through Events property and cannot be created as a stand-alone object.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Methods

GetEventSelection() GetEventSelection() GetEventSelection()

Returns the currently selected event notifications.

StartEvents() StartEvents() StartEvents()

Starts receiving events.

StopEvents() StopEvents() StopEvents()

Stops receiving events.

SubscribeToEvents(TableEventSet) SubscribeToEvents(TableEventSet) SubscribeToEvents(TableEventSet)

Specifies the table events to receive.

SubscribeToEvents(TableEventSet, ServerEventHandler) SubscribeToEvents(TableEventSet, ServerEventHandler) SubscribeToEvents(TableEventSet, ServerEventHandler)

Specifies the table events to receive and the event handler that handles the events.

UnsubscribeAllEvents() UnsubscribeAllEvents() UnsubscribeAllEvents()

Clears all event settings, and removes all event handlers.

UnsubscribeFromEvents(TableEventSet) UnsubscribeFromEvents(TableEventSet) UnsubscribeFromEvents(TableEventSet)

Clears the specified event settings, and removes all event handlers.

Events

ServerEvent ServerEvent ServerEvent

Specifies the event raised when an event occurs in Table object and the user has subscribed to the events from that object instance.

Applies to