This documentation is archived and is not being maintained.
SqlNotificationInfo Enumeration
Visual Studio 2008
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. | |
| 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. |
The SqlNotificationInfo 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.
Show: