TraceFile Class
The TraceFile class is a Trace object that represents a trace log file.
Assembly: Microsoft.SqlServer.ConnectionInfoExtended (in Microsoft.SqlServer.ConnectionInfoExtended.dll)
Microsoft.SqlServer.Management.Trace::TraceReader
Microsoft.SqlServer.Management.Trace::TraceReaderWriter
Microsoft.SqlServer.Management.Trace::TraceFile
| Name | Description | |
|---|---|---|
![]() | TraceFile() | Initializes a new instance of the TraceFile class. |
| Name | Description | |
|---|---|---|
![]() | Depth | Gets the depth value for the trace reader.(Inherited from TraceReader.) |
![]() | FieldCount | Gets the number of columns in the data.(Inherited from TraceReader.) |
![]() | IsClosed | Gets the Boolean property value that specifies whether the trace reader is closed.(Inherited from TraceReader.) |
![]() | Item[Int32] | Gets the column specified by the index position.(Inherited from TraceReader.) |
![]() | Item[String^] | Gets the column with the specified name.(Inherited from TraceReader.) |
![]() | RecordsAffected | Gets the number of records of data.(Inherited from TraceReader.) |
| Name | Description | |
|---|---|---|
![]() | Close() | Closes the trace reader and writer.(Inherited from TraceReaderWriter.) |
![]() | Dispose() | Deletes the trace reader information.(Inherited from TraceReader.) |
![]() | Equals(Object^) | (Inherited from Object.) |
![]() | Finalize() | (Inherited from Object.) |
![]() | GetBoolean(Int32) | Returns a Boolean value from the record at the specified column position.(Inherited from TraceReader.) |
![]() | GetByte(Int32) | Returns a Byte value from the record at the specified column position.(Inherited from TraceReader.) |
![]() | GetBytes(Int32, Int64, array<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) | Gets a character value of the specified column.(Inherited from TraceReader.) |
![]() | GetChars(Int32, array<Char>^, Int32, Int32, Int32) | Gets a character array value from the record at the specified column position.(Inherited from TraceReader.) |
![]() | GetChars(Int32, Int64, array<Char>^, Int32, Int32) | Gets a character array value from the record at the specified column position.(Inherited from TraceReader.) |
![]() | GetData(Int32) | Returns IDataReader object used when the field points to a remote data structure.(Inherited from TraceReader.) |
![]() | GetDataTypeName(Int32) | Gets the data type of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetDateTime(Int32) | Gets a DateTime value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetDecimal(Int32) | Gets a Decimal value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetDouble(Int32) | Gets a floating point value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetFieldType(Int32) | Returns the field type of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetFloat(Int32) | Gets a floating point value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetGuid(Int32) | Gets a Guid system value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetHashCode() | (Inherited from Object.) |
![]() | GetInt16(Int32) | Gets a small integer value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetInt32(Int32) | Gets an integer value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetInt64(Int32) | Gets a long integer value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetName(Int32) | Gets the name of the field at the specified column position.(Inherited from TraceReader.) |
![]() | GetOrdinal(String^) | Gets the ordinal value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetSchemaTable() | Gets a table that describes the schema.(Inherited from TraceReader.) |
![]() | GetStream(Int32) | Gets the stream of data.(Inherited from TraceReader.) |
![]() | GetString(Int32) | Gets a String value at the specified column position.(Inherited from TraceReader.) |
![]() | GetTimeSpan(Int32) | Gets a TimeSpan value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetType() | (Inherited from Object.) |
![]() | GetValue(Int32) | Gets a value of the data value at the specified column position.(Inherited from TraceReader.) |
![]() | GetValues(array<Object^>^) | Gets an array of values from the data value at the specified column position.(Inherited from TraceReader.) |
![]() | InitializeAsReader(String^) | Initializes the specified TraceFile object for reading data from the trace log file. |
![]() | InitializeAsReplayOutputWriter(String^) | Initializes the specified TraceFile object for writing data to the trace log file only. |
![]() | InitializeAsWriter(TraceReader^, String^) | Initializes the specified TraceFile object for reading trace data from a TraceReader object, analyzing the data, and writing data the referenced trace log file. |
![]() | IsDBNull(Int32) | Specifies whether the specified column is set to null. (Inherited from TraceReader.) |
![]() | IsNull(Int32) | Gets a Boolean value that specifies whether value of the data at the specified column position is null.(Inherited from TraceReader.) |
![]() | MemberwiseClone() | (Inherited from Object.) |
![]() | NextResult() | Moves to the next result in the trace.(Inherited from TraceReader.) |
![]() | Read() | Reads the trace record.(Inherited from TraceReader.) |
![]() | ToString() | (Inherited from Object.) |
![]() | TranslateSubclass(String^, String^, Int32) | Translates the sub class.(Inherited from TraceReader.) |
![]() | Write() | Writes the trace to the trace file or the trace table.(Inherited from TraceReaderWriter.) |
| Name | Description | |
|---|---|---|
![]() | currentRow | Specifies the current row.(Inherited from TraceReader.) |
| Name | Description | |
|---|---|---|
![]() | WriteNotify | Raises an event when the trace is written to the trace file or trace table.(Inherited from TraceReaderWriter.) |
With the TraceFile object you can:
Read from a trace log file.
Write to a trace log file.
In addition to the Trace and Replay objects, the trace log file can be accessed manually with Using SQL Server Profiler or using a set of Transact-SQL stored procedures called SQL Trace.
Readme_Tracer
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.




