Language

SqlNotificationInfo Enum

Definition

Namespace:
System.Data.SqlClient
Assembly:
System.Data.dll
Source:
System.Data.SqlClient.notsupported.cs

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

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.

public enum class SqlNotificationInfo
public enum SqlNotificationInfo
type SqlNotificationInfo = 
Public Enum SqlNotificationInfo
Inheritance
Object
ValueType
Enum
SqlNotificationInfo

Fields

Name Value Description
AlreadyChanged -2

The SqlDependency object already fired, and new commands cannot be added to it.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Unknown -1

Used when the info option sent by the server was not recognized by the client.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Truncate 0

One or more tables were truncated.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Insert 1

Data was changed by an INSERT statement.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Update 2

Data was changed by an UPDATE statement.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Delete 3

Data was changed by a DELETE statement.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Drop 4

An underlying object related to the query was dropped.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Alter 5

An underlying server object related to the query was modified.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Restart 6

The server was restarted (notifications are sent during restart.).

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Error 7

An internal server error occurred.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Query 8

A SELECT statement that cannot be notified or was provided.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Invalid 9

A statement was provided that cannot be notified (for example, an UPDATE statement).

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Options 10

The SET options were not set appropriately at subscription time.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Isolation 11

The statement was executed under an isolation mode that was not valid (for example, Snapshot).

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Expired 12

The SqlDependency object has expired.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Resource 13

Fires as a result of server resource pressure.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
PreviousFire 14

A previous statement has caused query notifications to fire under the current transaction.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
TemplateLimit 15

The subscribing query causes the number of templates on one of the target tables to exceed the maximum allowable limit.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
Merge 16

Used to distinguish the server-side cause for a query notification firing.

For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.

Remarks

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

Applies to

See also