SqlNotificationInfo Enumeration (System.Data.SqlClient)

SqlNotificationInfo Enumeration

Switch on low bandwidth view

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

SqlNotificationInfo Enumeration

This enumeration provides additional information about the different notifications that can be received by the dependency event handler.

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

Syntax

Visual Basic (Declaration)

Public Enumeration SqlNotificationInfo

Visual Basic (Usage)

Dim instance As SqlNotificationInfo

public enum SqlNotificationInfo

Visual C++

public enum class SqlNotificationInfo

JScript

public enum SqlNotificationInfo

Members

	Member name	Description
	Truncate	One or more tables were truncated.
	Insert	Data was changed by an INSERT statement.
	Update	Data was changed by an UPDATE statement.
	Delete	Data was changed by a DELETE statement.
	Drop	An underlying object related to the query was dropped.
	Alter	An underlying server object related to the query was modified.
	Restart	The server was restarted (notifications are sent during restart.).
	Error	An internal server error occurred.
	Query	A SELECT statement that cannot be notified or was provided.
	Invalid	A statement was provided that cannot be notified (for example, an UPDATE statement).
	Options	The SET options were not set appropriately at subscription time.
	Isolation	The statement was executed under an isolation mode that was not valid (for example, Snapshot).
	Expired	The SqlDependency object has expired.
	Resource	Fires as a result of server resource pressure.
	PreviousFire	A previous statement has caused query notifications to fire under the current transaction.
	TemplateLimit	The subscribing query causes the number of templates on one of the target tables to exceed the maximum allowable limit.
	Unknown	Used when the info option sent by the server was not recognized by the client.
	AlreadyChanged	The SqlDependency object already fired, and new commands cannot be added to it.
	Merge	Used to distinguish the server-side cause for a query notification firing.

Remarks

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

Platforms

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.

Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0

Reference

System.Data.SqlClient Namespace