SqlNotificationSource Enumeration
Indicates the source of the notification received by the dependency event handler.
Assembly: System.Data (in System.Data.dll)
| Member name | Description | |
|---|---|---|
| Client | 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. | |
| Data | Data has changed; for example, an insert, update, delete, or truncate operation occurred. | |
| Database | The database state changed; for example, the database related to the query was dropped or detached. | |
| Environment | 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. | |
| Execution | A run-time error occurred during execution. | |
| Object | A database object changed; for example, an underlying object related to the query was dropped or modified. | |
| Owner | Internal only; not intended to be used in your code. | |
| Statement | 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. | |
| System | A system-related event occurred. For example, there was an internal error, the server was restarted, or resource pressure caused the invalidation. | |
| Timeout | The subscription time-out expired. | |
| Unknown | Used when the source option sent by the server was not recognized by the client. |
The SqlNotificationSource enumeration is referenced by an instance of the SqlNotificationEventArgs class.
Query notifications are supported only for SELECT statements that meet a list of specific requirements. The following table provides links to the Service Broker and Query Notifications documentation in SQL Server Books Online.
SQL Server Books Online
Available since 2.0