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
)
参数
- ecParent
The parent EventClass for the EventChronicleRule. This parameter sets the Parent property.
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)