Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

The SqlNotificationSource enumeration is referenced by an instance of the SqlNotificationEventArgs class.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

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

.NET Framework

Supported in: 3.5, 3.0, 2.0
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.