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)