SqlNotificationInfo Enumeration

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

Syntax

public enum SqlNotificationInfo

Member Name	Description
AlreadyChanged	The SqlDependency object already fired, and new commands cannot be added to it.
Alter	An underlying server object related to the query was modified.
Delete	Data was changed by a DELETE statement.
Drop	An underlying object related to the query was dropped.
Error	An internal server error occurred.
Expired	The SqlDependency object has expired.
Insert	Data was changed by an INSERT statement.
Invalid	A statement was provided that cannot be notified (for example, an UPDATE statement).
Isolation	The statement was executed under an isolation mode that was not valid (for example, Snapshot).
Options	The SET options were not set appropriately at subscription time.
PreviousFire	A previous statement has caused query notifications to fire under the current transaction.
Query	A SELECT statement that cannot be notified or was provided.
Resource	Fires as a result of server resource pressure.
Restart	The server was restarted (notifications are sent during restart.).
TemplateLimit	The subscribing query causes the number of templates on one of the target tables to exceed the maximum allowable limit.
Truncate	One or more tables were truncated.
Unknown	Used when the info option sent by the server was not recognized by the client.
Update	Data was changed by an UPDATE statement.

Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 2.0.0.0
Since: .NET 2.0