TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Trace Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Defines a trace that can be queried.

  
      Profiler syntax  
<Traces>  
   <Trace>  
      <Name>...</Name>  
      <ID>...</ID>  
      <Description>...</Description>  
      <CreatedTimestamp>...</CreatedTimestamp>  
      <LastSchemaUpdate>...</LastSchemaUpdate>  
      <LogFileName>...</LogFileName>  
      <LogFileAppend>...</LogFileAppend>  
      <LogFileSize>...</LogFileSize>  
      <Audit>...</Audit>  
      <LogFileRollover>...</LogFileRollover>  
      <AutoRestart>...</AutoRestart>  
      <StopTime>...</StopTime>  
      <Filter>...</Filter>  
      <Events>...</Events>  
      <Annotations>...</Annotations>  
   </Trace>  
</Traces>  

  
      Extended Events syntax  
<Traces>  
   <Trace>  
      <Name>...</Name>  
      <ID>...</ID>  
      <Description>...</Description>  
      <CreatedTimestamp>...</CreatedTimestamp>  
      <LastSchemaUpdate>...</LastSchemaUpdate>  
      <XEvent>...</XEvent>  
      <Annotations>...</Annotations>  
   </Trace>  
</Traces>  

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
RelationshipElement
Parent elementsTraces
Child elementsAnnotations, Audit, AutoRestart, CreatedTimestamp, Description, Events, Filter, ID, LastSchemaUpdate, LogFileAppend, LogFileName, LogFileRollover, LogFileSize, Name, StopTime

The corresponding element in the Analysis Management Objects (AMO) object model is Trace.

Server Element (ASSL)
Objects (ASSL)

Community Additions

ADD
Show:
© 2016 Microsoft