Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

EventString Element (DTA)

 

Specifies a Transact-SQL script workload directly in the XML input file. 


<Workload>
    <EventString Weight="...">
    ...code removed here...
    </EventString>
</Workload>

Attribute

Description

Weight

Optional. Specifies the query weight factor (a factor of importance) for the specified event. Use a float data type to specify the weight. For example, Weight="100.01". The minimum value you can specify for Weight is "0".

Characteristic

Description

Data type and length

string, length is unlimited.

Default value

None.

Occurrence

Required once if no other type of workload is specified. You must specify an EventString, a File, or a Database child element for the Workload parent, but only one type can be used. For example, if you specify a workload with the EventString element, then you cannot also specify a workload with the File element in the same XML input file.

Relationship

Elements

Parent element

Workload Element (DTA)

Child elements

None.

Legacy Code Example

For a usage example of this element, see the XML Input File Sample with Inline Workload (DTA) .

Community Additions

ADD
Show:
© 2015 Microsoft