Export (0) Print
Expand All

SqlNotificationSource Enumeration

Indicates the source of the notification received by the dependency event handler.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public enum SqlNotificationSource

Member nameDescription
ClientA 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.
DataData has changed; for example, an insert, update, delete, or truncate operation occurred.
DatabaseThe database state changed; for example, the database related to the query was dropped or detached.
EnvironmentThe 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.
ExecutionA run-time error occurred during execution.
ObjectA database object changed; for example, an underlying object related to the query was dropped or modified.
OwnerInternal only; not intended to be used in your code.
StatementThe 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.
SystemA system-related event occurred. For example, there was an internal error, the server was restarted, or resource pressure caused the invalidation.
TimeoutThe subscription time-out expired.
UnknownUsed 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

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft