EventChronicle Class
Represents a Notification Services application event chronicle, which is supplemental storage for event data.
Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Sintaxis
'Declaración
Public NotInheritable Class EventChronicle
Inherits NamedSmoObject
public sealed class EventChronicle : NamedSmoObject
public ref class EventChronicle sealed : public NamedSmoObject
public final class EventChronicle extends NamedSmoObject
public final class EventChronicle extends NamedSmoObject
Notas
Event chronicles are optional; use them only if you need to maintain event information outside of the event tables used by an event class. A common reason to use an event chronicle is to store and maintain event data for scheduled subscriptions.
Each EventChronicle must have one or more Transact-SQL statements specified using the SqlStatements property.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Nmo.EventChronicle
Ejemplo
The following examples show how to define an event chronicle and add it to the collection of chronicles for an event class:
// Define a chronicle for the class
EventChronicle ec1 =
new EventChronicle(flightEvents, "FlightEventChonicle");
ec1.SqlStatements.Add(
"CREATE TABLE MyAppSchema.FlightEventChronicle " +
" (LeavingFrom nvarchar(6), GoingTo nvarchar(6), " +
" Price float);");
ec1.SqlStatements.Add(
"CREATE INDEX FlightEventChronicleIndex " +
"ON MyAppSchema.FlightEventChronicle " +
"( LeavingFrom, GoingTo );");
flightEvents.EventChronicles.Add(ec1);
' Define a chronicle for the class.
Dim ec1 As EventChronicle = _
New EventChronicle(flightEvents, "FlightEventChonicle")
ec1.SqlStatements.Add( _
"CREATE TABLE MyAppSchema.FlightEventChronicle " + _
" (LeavingFrom nvarchar(6), GoingTo nvarchar(6), " + _
" Price float);")
ec1.SqlStatements.Add( _
"CREATE INDEX FlightEventChronicleIndex " + _
"ON MyAppSchema.FlightEventChronicle " + _
"( LeavingFrom, GoingTo );")
flightEvents.EventChronicles.Add(ec1)
Seguridad para subprocesos
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
EventChronicle Members
Microsoft.SqlServer.Management.Nmo Namespace
Otros recursos
Definir crónicas para una clase de evento
Chronicle Element for EventClass/Chronicles (ADF)