snsData

Data has changed; for example, an insert, update, delete, or truncate operation occurred.

snsTimeout

The subscription time-out expired.

snsObject

A database object changed; for example, an underlying object related to the query was dropped or modified.

snsDatabase

The database state changed; for example, the database related to the query was dropped or detached.

snsSystem

A system-related event occurred. For example, there was an internal error, the server was restarted, or resource pressure caused the invalidation.

snsStatement

The Transact-SQL statement is not valid for notifications; for example, a SELECT statement that could not be notified or a non-SELECT statement was executed.

snsEnvironment

The run-time environment was not compatible with notifications; for example, the isolation level was set to snapshot, or one or more SET options are not compatible.

snsExecution

A run-time error occurred during execution.

snsOwner

Internal only; not intended to be used in your code.

snsClient

A client-initiated notification occurred, such as a client-side time-out or as a result of attempting to add a command to a dependency that has already fired.

snsUnknown

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