TraceTable Class

The TraceTable class is a Trace object that represents a table of trace information.

Namespace: Microsoft.SqlServer.Management.Trace
Assembly: Microsoft.SqlServer.ConnectionInfo (in microsoft.sqlserver.connectioninfo.dll)

Syntax

'Declaration
<ComVisibleAttribute(False)> _
Public Class TraceTable
    Inherits TraceReaderWriter
[ComVisibleAttribute(false)] 
public class TraceTable : TraceReaderWriter
[ComVisibleAttribute(false)] 
public ref class TraceTable : public TraceReaderWriter
/** @attribute ComVisibleAttribute(false) */ 
public class TraceTable extends TraceReaderWriter
ComVisibleAttribute(false) 
public class TraceTable extends TraceReaderWriter

Remarks

With the TraceTable object you can:

  • Read from a trace table.

  • Write to a trace table.

In addition to the Trace and Replay objects, the trace table can be accessed manually with SQL Server Profiler Reference or using a set of Transact-SQL stored procedures called Introducing SQL Trace.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Trace.TraceReader
     Microsoft.SqlServer.Management.Trace.TraceReaderWriter
      Microsoft.SqlServer.Management.Trace.TraceTable

Example

Readme_Tracer

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

TraceTable Members
Microsoft.SqlServer.Management.Trace Namespace

Other Resources

Trace Flags (Transact-SQL)
Using SQL Server Profiler