This documentation is archived and is not being maintained.
SqlNotificationInfo Enumeration
Visual Studio 2010
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 | |
|---|---|---|
| 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. | |
| Merge | Used to distinguish the server-side cause for a query notification firing. | |
| 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. |
The SqlNotificationInfo enumeration is referenced by an instance of the SqlNotificationEventArgs class.
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Show: