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