TraceTable TraceTable TraceTable Class

Definition

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

public ref class TraceTable : Microsoft::SqlServer::Management::Trace::TraceReaderWriter
[System.Runtime.InteropServices.ComVisible(false)]
public class TraceTable : Microsoft.SqlServer.Management.Trace.TraceReaderWriter
Public Class TraceTable
Inherits TraceReaderWriter
Inheritance
Attributes

Examples

Readme_Tracer

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 Using SQL Server Profiler or using a set of Transact-SQL stored procedures called SQL Trace.

Constructors

TraceTable() TraceTable() TraceTable()

Initializes a new instance of the TraceTable class.

Methods

Close() Close() Close()

Closes the trace reader and writer.

(Inherited from TraceReaderWriter)
Dispose() Dispose() Dispose()

Deletes the trace reader information.

(Inherited from TraceReader)
GetBoolean(Int32) GetBoolean(Int32) GetBoolean(Int32)

Returns a Boolean value from the record at the specified column position.

(Inherited from TraceReader)
GetByte(Int32) GetByte(Int32) GetByte(Int32)

Returns a Byte value from the record at the specified column position.

(Inherited from TraceReader)
GetBytes(Int32, Int64, Byte[], Int32, Int32) GetBytes(Int32, Int64, Byte[], Int32, Int32) GetBytes(Int32, Int64, Byte[], Int32, Int32)

Gets a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset.

(Inherited from TraceReader)
GetChar(Int32) GetChar(Int32) GetChar(Int32)

Gets a character value of the specified column.

(Inherited from TraceReader)
GetChars(Int32, Char[], Int32, Int32, Int32) GetChars(Int32, Char[], Int32, Int32, Int32) GetChars(Int32, Char[], Int32, Int32, Int32)

Gets a character array value from the record at the specified column position.

(Inherited from TraceReader)
GetChars(Int32, Int64, Char[], Int32, Int32) GetChars(Int32, Int64, Char[], Int32, Int32) GetChars(Int32, Int64, Char[], Int32, Int32)

Gets a character array value from the record at the specified column position.

(Inherited from TraceReader)
GetData(Int32) GetData(Int32) GetData(Int32)

Returns IDataReader object used when the field points to a remote data structure.

(Inherited from TraceReader)
GetDataTypeName(Int32) GetDataTypeName(Int32) GetDataTypeName(Int32)

Gets the data type of the data value at the specified column position.

(Inherited from TraceReader)
GetDateTime(Int32) GetDateTime(Int32) GetDateTime(Int32)

Gets a DateTime value of the data value at the specified column position.

(Inherited from TraceReader)
GetDecimal(Int32) GetDecimal(Int32) GetDecimal(Int32)

Gets a Decimal value of the data value at the specified column position.

(Inherited from TraceReader)
GetDouble(Int32) GetDouble(Int32) GetDouble(Int32)

Gets a floating point value of the data value at the specified column position.

(Inherited from TraceReader)
GetFieldType(Int32) GetFieldType(Int32) GetFieldType(Int32)

Returns the field type of the data value at the specified column position.

(Inherited from TraceReader)
GetFloat(Int32) GetFloat(Int32) GetFloat(Int32)

Gets a floating point value of the data value at the specified column position.

(Inherited from TraceReader)
GetGuid(Int32) GetGuid(Int32) GetGuid(Int32)

Gets a Guid system value of the data value at the specified column position.

(Inherited from TraceReader)
GetInt16(Int32) GetInt16(Int32) GetInt16(Int32)

Gets a small integer value of the data value at the specified column position.

(Inherited from TraceReader)
GetInt32(Int32) GetInt32(Int32) GetInt32(Int32)

Gets an integer value of the data value at the specified column position.

(Inherited from TraceReader)
GetInt64(Int32) GetInt64(Int32) GetInt64(Int32)

Gets a long integer value of the data value at the specified column position.

(Inherited from TraceReader)
GetName(Int32) GetName(Int32) GetName(Int32)

Gets the name of the field at the specified column position.

(Inherited from TraceReader)
GetOrdinal(String) GetOrdinal(String) GetOrdinal(String)

Gets the ordinal value of the data value at the specified column position.

(Inherited from TraceReader)
GetSchemaTable() GetSchemaTable() GetSchemaTable()

Gets a table that describes the schema.

(Inherited from TraceReader)
GetStream(Int32) GetStream(Int32) GetStream(Int32)

Gets the stream of data.

(Inherited from TraceReader)
GetString(Int32) GetString(Int32) GetString(Int32)

Gets a String value at the specified column position.

(Inherited from TraceReader)
GetTimeSpan(Int32) GetTimeSpan(Int32) GetTimeSpan(Int32)

Gets a TimeSpan value of the data value at the specified column position.

(Inherited from TraceReader)
GetValue(Int32) GetValue(Int32) GetValue(Int32)

Gets a value of the data value at the specified column position.

(Inherited from TraceReader)
GetValues(Object[]) GetValues(Object[]) GetValues(Object[])

Gets an array of values from the data value at the specified column position.

(Inherited from TraceReader)
InitializeAsReader(ConnectionInfoBase, String, String) InitializeAsReader(ConnectionInfoBase, String, String) InitializeAsReader(ConnectionInfoBase, String, String)

Initializes a new instance of the TraceTable class for reading trace data.

InitializeAsReplayOutputWriter(ConnectionInfoBase, String) InitializeAsReplayOutputWriter(ConnectionInfoBase, String) InitializeAsReplayOutputWriter(ConnectionInfoBase, String)

Initializes a new instance of the TraceTable class for writing replay trace information.

InitializeAsWriter(TraceReader, ConnectionInfoBase, String) InitializeAsWriter(TraceReader, ConnectionInfoBase, String) InitializeAsWriter(TraceReader, ConnectionInfoBase, String)

Initializes the specified TraceTable object for reading trace data from a TraceReader object, analyzing the data, and writing data to the referenced trace table.

IsDBNull(Int32) IsDBNull(Int32) IsDBNull(Int32)

Specifies whether the specified column is set to null.

(Inherited from TraceReader)
IsNull(Int32) IsNull(Int32) IsNull(Int32)

Gets a Boolean value that specifies whether value of the data at the specified column position is null.

(Inherited from TraceReader)
NextResult() NextResult() NextResult()

Moves to the next result in the trace.

(Inherited from TraceReader)
Read() Read() Read()

Reads the trace record.

(Inherited from TraceReader)
TranslateSubclass(String, String, Int32) TranslateSubclass(String, String, Int32) TranslateSubclass(String, String, Int32)

Translates the sub class.

(Inherited from TraceReader)
Write() Write() Write()

Writes the trace to the trace file or the trace table.

(Inherited from TraceReaderWriter)

Fields

currentRow currentRow currentRow

Specifies the current row.

(Inherited from TraceReader)

Properties

Depth Depth Depth

Gets the depth value for the trace reader.

(Inherited from TraceReader)
FieldCount FieldCount FieldCount

Gets the number of columns in the data.

(Inherited from TraceReader)
IsClosed IsClosed IsClosed

Gets the Boolean property value that specifies whether the trace reader is closed.

(Inherited from TraceReader)
Item[Int32] Item[Int32] Item[Int32]

Gets the column specified by the index position.

(Inherited from TraceReader)
Item[String] Item[String] Item[String]

Gets the column with the specified name.

(Inherited from TraceReader)
RecordsAffected RecordsAffected RecordsAffected

Gets the number of records of data.

(Inherited from TraceReader)

Events

WriteNotify WriteNotify WriteNotify

Raises an event when the trace is written to the trace file or trace table.

(Inherited from TraceReaderWriter)

Applies to