This documentation is archived and is not being maintained.

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

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

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

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

.NET Framework

Supported in: 3.5, 3.0, 2.0