共用方式為

EventChronicleRule Constructor

  • 發行項

Initializes a new instance of the EventChronicleRule class with an EventClass and a name.

命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Sub New ( _
    ecParent As EventClass, _
    name As String _
)

public EventChronicleRule (
    EventClass ecParent,
    string name
)

public:
EventChronicleRule (
    EventClass^ ecParent, 
    String^ name
)

public EventChronicleRule (
    EventClass ecParent, 
    String name
)

public function EventChronicleRule (
    ecParent : EventClass, 
    name : String
)

參數

  • name
    The String of up to 256 characters that specifies the name of the EventChronicleRule.

    You cannot change the name. To rename an event chronicle rule, you must remove the rule and then add a new rule.

範例

The following example shows how to create an event chronicle rule that simply copies all events to a chronicle:

// Define the event chronicle rule
EventChronicleRule ec1Rule = 
    new EventChronicleRule(flightEvents, 
    "FlightEventChronicleRule");
ec1Rule.Action = "INSERT MyAppSchema.FlightEventChronicle " + 
    " (LeavingFrom, GoingTo, Price) " + 
    " SELECT LeavingFrom, GoingTo, Price " + 
    " FROM MyAppSchema.FlightEvents;";
ec1Rule.ActionTimeout = new TimeSpan(0, 1, 20);
flightEvents.EventChronicleRule = ec1Rule;

' Define the event chronicle rule
Dim ec1Rule As EventChronicleRule = _
    New EventChronicleRule(flightEvents, _
        "FlightEventChronicleRule")
ec1Rule.Action = _
    "INSERT MyAppSchema.FlightEventChronicle " + _
    " (LeavingFrom, GoingTo, Price) " + _
    " SELECT LeavingFrom, GoingTo, Price " + _
    " FROM MyAppSchema.FlightEvents;"
ec1Rule.ActionTimeout = New TimeSpan(0, 1, 20)
flightEvents.EventChronicleRule = ec1Rule

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

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

其他資源

定義事件紀事輯規則
RuleName Element for ChronicleRule (ADF)
ChronicleRule Element (ADF)