SubscriptionChronicle Constructor (SubscriptionClass, String)

Initializes a new instance of the SubscriptionChronicle class with a parent subscription class and a name.

Пространство имен: Microsoft.SqlServer.Management.Nmo
Сборка: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Синтаксис

'Декларация
Public Sub New ( _
    subscriptionClass As SubscriptionClass, _
    name As String _
)

public SubscriptionChronicle (
    SubscriptionClass subscriptionClass,
    string name
)

public:
SubscriptionChronicle (
    SubscriptionClass^ subscriptionClass, 
    String^ name
)

public SubscriptionChronicle (
    SubscriptionClass subscriptionClass, 
    String name
)

public function SubscriptionChronicle (
    subscriptionClass : SubscriptionClass, 
    name : String
)

Параметры

• subscriptionClass
  The parent SubscriptionClass for the subscription chronicle.

• name
  A String, between 1 and 64 characters in length, that specifies the name of the subscription chronicle. This is a logical name, and not the name of the chronicle table, which you define using the SqlStatements property.

  You cannot change the name. To rename a subscription chronicle, you must remove the chronicle and then add a new chronicle that has a new name. For existing instances, you may need to rename the existing chronicle table so that you can copy data between it and the new chronicle.

Замечания

Subscription class names must conform to Microsoft SQL Server identifier naming conventions and must be unique within the application. For more information about SQL Server identifier naming conventions, see Идентификаторы.

If you update the name, updating the application re-creates the subscription class to which it corresponds. Notification Services renames the existing subscription tables by appending Old to the table name and then creates new tables. Existing subscription table indexes are left unchanged.

If you want to transfer data between the old and new subscription tables, it must be done manually. For more information, see Обновление приложения.

Пример

The following examples show how to create a subscription chronicle:

// 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);

' Define a chronicle for the subscription class
Dim sc1 As SubscriptionChronicle = 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)

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

SubscriptionChronicle Class
SubscriptionChronicle Members
Microsoft.SqlServer.Management.Nmo Namespace

Другие ресурсы

Определение хроники для класса подписки
Chronicle Element for SubscriptionClass/Chronicles (ADF)