TraceTable Members

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

The following tables list the members exposed by the TraceTable type.

Public Constructors

  Name Description
TraceTable Initializes a new instance of the TraceTable class.

Top

Protected Fields

  Name Description
ms220904.protfield(en-US,SQL.90).gif currentRow  Specifies the current row. (inherited from TraceReader)

Top

Public Properties

  Name Description
ms220904.pubproperty(en-US,SQL.90).gif Depth  Gets the depth value for the trace reader. (inherited from TraceReader)
ms220904.pubproperty(en-US,SQL.90).gif FieldCount  Gets the number of columns in the data. (inherited from TraceReader)
ms220904.pubproperty(en-US,SQL.90).gif IsClosed  Gets the Boolean property value that specifies whether the trace reader is closed. (inherited from TraceReader)
ms220904.pubproperty(en-US,SQL.90).gif Item  Overloaded. (inherited from TraceReader )
ms220904.pubproperty(en-US,SQL.90).gif RecordsAffected  Gets the number of records of data. (inherited from TraceReader)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220904.pubmethod(en-US,SQL.90).gif Close  Closes the trace reader and writer. (inherited from TraceReaderWriter)
ms220904.pubmethod(en-US,SQL.90).gif Dispose  Deletes the trace reader information. (inherited from TraceReader)
ms220904.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220904.pubmethod(en-US,SQL.90).gif GetBoolean  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetByte  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetBytes  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetChar  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetChars  Overloaded. (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetData  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetDataTypeName  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetDateTime  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetDecimal  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetDouble  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetFieldType  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetFloat  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetGuid  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220904.pubmethod(en-US,SQL.90).gif GetInt16  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetInt32  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetInt64  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetName  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetOrdinal  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetSchemaTable  Gets a table that describes the schema. (inherited from TraceReader)
ms220904.pubmethod(en-US,SQL.90).gif GetStream  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetString  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetTimeSpan  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220904.pubmethod(en-US,SQL.90).gif GetValue  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif GetValues  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif InitializeAsReader Initializes a new instance of the TraceTable class for reading trace data.
ms220904.pubmethod(en-US,SQL.90).gif InitializeAsReplayOutputWriter Initializes a new instance of the TraceTable class for writing replay trace information.
ms220904.pubmethod(en-US,SQL.90).gif InitializeAsWriter Initializes the specified TraceTable object for reading trace data from a TraceReader object, analyzing the data, and writing data to the referenced trace table.
ms220904.pubmethod(en-US,SQL.90).gif IsDBNull  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif IsNull  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif NextResult  Moves to the next result in the trace. (inherited from TraceReader)
ms220904.pubmethod(en-US,SQL.90).gif Read  Reads the trace record. (inherited from TraceReader)
ms220904.pubmethod(en-US,SQL.90).gifms220904.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220904.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms220904.pubmethod(en-US,SQL.90).gif TranslateSubclass  (inherited from TraceReader )
ms220904.pubmethod(en-US,SQL.90).gif Write  Writes the trace to the trace file or the trace table. (inherited from TraceReaderWriter)

Top

Protected Methods

  Name Description
ms220904.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220904.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

Public Events

  Name Description
ms220904.pubevent(en-US,SQL.90).gif WriteNotify  Raises an event when the trace is written to the trace file or trace table. (inherited from TraceReaderWriter)

Top

See Also

Reference

TraceTable Class
Microsoft.SqlServer.Management.Trace Namespace

Other Resources

Trace Flags (Transact-SQL)
Using SQL Server Profiler