SqlNotificationSource Enum


指示依赖项事件处理程序所接收的通知的源。Indicates the source of the notification received by the dependency event handler.

public enum class SqlNotificationSource
public enum SqlNotificationSource
type 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.


SqlNotificationSource 枚举由 SqlNotificationEventArgs 类的实例引用。The 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.

Applies to

See also