SqlNotificationInfo Enumeration

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
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).

Merge

Used to distinguish the server-side cause for a query notification firing.

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.

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

.NET Framework
Available since 2.0
Return to top
Show:
© 2016 Microsoft