Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

DISCOVER_TRACES Rowset

SQL Server 2012

Provides information about traces that are currently active on the server.

Applies to: tabular models, multidimensional models

The DISCOVER_TRACES rowset contains the following columns.

Column name

Type indicator

Description

TraceID

DBTYPE_WSTR

The trace ID.

TraceName

DBTYPE_WSTR

The trace name.

LogFileName

DBTYPE_WSTR

The trace log file name.

LogFileSize

DBTYPE_I4

The trace log file size.

LogFileRollover

DBTYPE_BOOL

When true, indicates that the log file should be rolled over; otherwise false.

AutoRestart

DBTYPE_BOOL

When true, indicates that the auto restart option is enabled; otherwise false.

CreationTime

DBTYPE_TIME

The date and time that the trace was created.

StopTime

DBTYPE_TIME

The stop time of a trace.

Type

PF_DBTYPE_WSTR

The type of trace.

This schema rowset is not sorted.

The DISCOVER_TRACES rowset can be restricted on the columns listed in the following table.

Column name

Type indicator

Restriction State

TraceId

DBTYPE_I4

Optional.

Type

WSTR

Optional.

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.

Argument

Value

GUID

a07ccd1a-8148-11d0-87bb-00c04fc33942

String

DISCOVER_TRACES

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.