Export (0) Print
Expand All

SqlNotificationInfo Enumeration

This enumeration provides additional information about the different notifications that can be received by the dependency event handler.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public enum SqlNotificationInfo

Member nameDescription
AlreadyChangedThe SqlDependency object already fired, and new commands cannot be added to it.
AlterAn underlying server object related to the query was modified.
DeleteData was changed by a DELETE statement.
DropAn underlying object related to the query was dropped.
ErrorAn internal server error occurred.
ExpiredThe SqlDependency object has expired.
InsertData was changed by an INSERT statement.
InvalidA statement was provided that cannot be notified (for example, an UPDATE statement).
IsolationThe statement was executed under an isolation mode that was not valid (for example, Snapshot).
MergeUsed to distinguish the server-side cause for a query notification firing.
OptionsThe SET options were not set appropriately at subscription time.
PreviousFireA previous statement has caused query notifications to fire under the current transaction.
QueryA SELECT statement that cannot be notified or was provided.
ResourceFires as a result of server resource pressure.
RestartThe server was restarted (notifications are sent during restart.).
TemplateLimitThe subscribing query causes the number of templates on one of the target tables to exceed the maximum allowable limit.
TruncateOne or more tables were truncated.
UnknownUsed when the info option sent by the server was not recognized by the client.
UpdateData was changed by an UPDATE statement.

The SqlNotificationInfo enumeration is referenced by an instance of the SqlNotificationEventArgs class.

.NET Framework

Supported in: 4.5.3, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft