SqlNotificationSource 枚举
定义
指示依赖项事件处理程序所接收的通知的源。Indicates the source of the notification received by the dependency event handler.
public enum class SqlNotificationSourcepublic enum SqlNotificationSourcetype SqlNotificationSource = Public Enum SqlNotificationSource- 继承
字段
| Client | -2 | 发生了客户端启动的通知（如由于发生客户端超时，或尝试向已激发的依赖项添加命令）。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 | 0 | 数据已更改；例如，发生了插入、更新、删除或截断操作。Data has changed; for example, an insert, update, delete, or truncate operation occurred. |
| Database | 3 | 数据库状态已更改；例如，与查询相关的数据库已被删除或分离。The database state changed; for example, the database related to the query was dropped or detached. |
| Environment | 6 | 运行时环境与通知不兼容；例如，隔离级别设置为快照，或一个或多个 SET 选项不兼容。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 | 7 | 执行的过程中发生运行时错误。A run-time error occurred during execution. |
| Object | 2 | 某数据库对象已更改；例如，与查询相关的某基础对象已被删除或修改。A database object changed; for example, an underlying object related to the query was dropped or modified. |
| Owner | 8 | 仅限内部；不应在代码中使用。Internal only; not intended to be used in your code. |
| Statement | 5 | Transact-SQL 语句对通知无效；例如，未能通知 SELECT 语句或执行了非 SELECT 语句。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 | 4 | 发生了系统相关的事件。A system-related event occurred. 例如，存在内部错误、服务器被重新启动或资源压力导致失效。For example, there was an internal error, the server was restarted, or resource pressure caused the invalidation. |
| Timeout | 1 | 订阅超时已过期。The subscription time-out expired. |
| Unknown | -1 | 当客户端无法识别服务器发送的源选项时使用。Used when the source option sent by the server was not recognized by the client. |
注解
枚举由SqlNotificationEventArgs类的实例引用。 SqlNotificationSourceThe SqlNotificationSource enumeration is referenced by an instance of the SqlNotificationEventArgs class.
仅对满足一系列特定要求的 SELECT 语句支持查询通知。Query notifications are supported only for SELECT statements that meet a list of specific requirements. 有关详细信息, 请参阅SQL Server Service Broker和使用查询通知。For more information, see SQL Server Service Broker and Working with Query Notifications.