sniTruncate

One or more tables were truncated.

sniInsert

Data was changed by an INSERT statement.

sniUpdate

Data was changed by an UPDATE statement.

sniDelete

Data was changed by a DELETE statement.

sniDrop

An underlying object related to the query was dropped.

sniAlter

An underlying server object related to the query was modified.

sniRestart

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

sniError

An internal server error occurred.

sniQuery

A SELECT statement that cannot be notified or was provided.

sniInvalid

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

sniOptions

The SET options were not set appropriately at subscription time.

sniIsolation

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

sniExpired

The SqlDependency object has expired.

sniResource

Fires as a result of server resource pressure.

sniPreviousFire

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

sniTemplateLimit

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

sniMerge

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

sniAlreadyChanged

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

sniUnknown

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