Notification Source 枚举
指示依赖项事件处理程序所接收的通知的源。Indicates the source of the notification received by the dependency event handler.
public enum class SqlNotificationSource
public enum SqlNotificationSource
type SqlNotificationSource =
Public Enum SqlNotificationSource
发生了客户端启动的通知（如由于发生客户端超时，或尝试向已激发的依赖项添加命令）。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 has changed; for example, an insert, update, delete, or truncate operation occurred.
数据库状态已更改；例如，与查询相关的数据库已被删除或分离。The database state changed; for example, the database related to the query was dropped or detached.
运行时环境与通知不兼容；例如，隔离级别设置为快照，或一个或多个 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.
执行的过程中发生运行时错误。A run-time error occurred during execution.
某数据库对象已更改；例如，与查询相关的某基础对象已被删除或修改。A database object changed; for example, an underlying object related to the query was dropped or modified.
仅限内部；不应在代码中使用。Internal only; not intended to be used in your code.
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.
发生了系统相关的事件。A system-related event occurred. 例如，存在内部错误、服务器被重新启动或资源压力导致失效。For example, there was an internal error, the server was restarted, or resource pressure caused the invalidation.
订阅超时已过期。The subscription time-out expired.
当客户端无法识别服务器发送的源选项时使用。Used when the source option sent by the server was not recognized by the client.
仅对满足一系列特定要求的 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.