SubscriptionChronicle Class

Represents a Notification Services application subscription chronicle, which is supplemental storage for subscription data.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

public sealed class SubscriptionChronicle : NamedSmoObject
public final class SubscriptionChronicle extends NamedSmoObject
public final class SubscriptionChronicle extends NamedSmoObject

Subscription chronicles are optional; use them only if you need to maintain subscription information outside of the subscription tables used by a subscription class. A common reason to use a subscription chronicle is to store and maintain when the subscription last produced a notification.


The following examples show how to define a subscription chronicle and add it to a subscription class:

// Define a chronicle for the subscription class
SubscriptionChronicle sc1 = new SubscriptionChronicle(
    flightSubscriptions, "FlightSubChronicle");
sc1.SqlStatements.Add(
    "CREATE TABLE MyAppSchema.FlightSubChronicle " + 
    " (SubscriptionId bigint, LeavingFrom nvarchar(6), " + 
    "  GoingTo nvarchar(6), Price float);");
sc1.SqlStatements.Add(
    "CREATE INDEX FlightSubChronicleIndex  " +
    " ON MyAppSchema.FlightSubChronicle " +
    " ( LeavingFrom, GoingTo );");
flightSubscriptions.SubscriptionChronicles.Add(sc1);

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.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show: