SqlNotificationInfo SqlNotificationInfo SqlNotificationInfo SqlNotificationInfo Enum


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

public enum class SqlNotificationInfo
public enum SqlNotificationInfo
type SqlNotificationInfo = 
Public Enum SqlNotificationInfo


AlreadyChanged AlreadyChanged AlreadyChanged AlreadyChanged -2

The SqlDependency object already fired, and new commands cannot be added to it.

Alter Alter Alter Alter 5

An underlying server object related to the query was modified.

Delete Delete Delete Delete 3

Data was changed by a DELETE statement.

Drop Drop Drop Drop 4

An underlying object related to the query was dropped.

Error Error Error Error 7

An internal server error occurred.

Expired Expired Expired Expired 12

The SqlDependency object has expired.

Insert Insert Insert Insert 1

Data was changed by an INSERT statement.

Invalid Invalid Invalid Invalid 9

A statement was provided that cannot be notified (for example, an UPDATE statement).

Isolation Isolation Isolation Isolation 11

The statement was executed under an isolation mode that was not valid (for example, Snapshot).

Merge Merge Merge Merge 16

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

Options Options Options Options 10

The SET options were not set appropriately at subscription time.

PreviousFire PreviousFire PreviousFire PreviousFire 14

A previous statement has caused query notifications to fire under the current transaction.

Query Query Query Query 8

A SELECT statement that cannot be notified or was provided.

Resource Resource Resource Resource 13

Fires as a result of server resource pressure.

Restart Restart Restart Restart 6

The server was restarted (notifications are sent during restart.).

TemplateLimit TemplateLimit TemplateLimit TemplateLimit 15

The subscribing query causes the number of templates on one of the target tables to exceed the maximum allowable limit.

Truncate Truncate Truncate Truncate 0

One or more tables were truncated.

Unknown Unknown Unknown Unknown -1

Used when the info option sent by the server was not recognized by the client.

Update Update Update Update 2

Data was changed by an UPDATE statement.


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

Applies to

See also