TraceFile 類別

The TraceFile class is a Trace object that represents a trace log file.

繼承階層

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

命名空間：  Microsoft.SqlServer.Management.Trace
組件：  Microsoft.SqlServer.ConnectionInfoExtended (在 Microsoft.SqlServer.ConnectionInfoExtended.dll 中)

語法

'宣告
<ComVisibleAttribute(False)> _
Public Class TraceFile _
    Inherits TraceReaderWriter
'用途
Dim instance As TraceFile

[ComVisibleAttribute(false)]
public class TraceFile : TraceReaderWriter

[ComVisibleAttribute(false)]
public ref class TraceFile : public TraceReaderWriter

[<ComVisibleAttribute(false)>]
type TraceFile =  
    class 
        inherit TraceReaderWriter 
    end

public class TraceFile extends TraceReaderWriter

TraceFile 型別公開下列成員。

建構函式

	名稱	說明
	TraceFile	Initializes a new instance of the TraceFile class.

上層

屬性

	名稱	說明
	Depth	Gets the depth value for the trace reader. (繼承自 TraceReader。)
	FieldCount	Gets the number of columns in the data. (繼承自 TraceReader。)
	IsClosed	Gets the Boolean property value that specifies whether the trace reader is closed. (繼承自 TraceReader。)
	Item[Int32]	Gets the column specified by the index position. (繼承自 TraceReader。)
	Item[String]	Gets the column with the specified name. (繼承自 TraceReader。)
	RecordsAffected	Gets the number of records of data. (繼承自 TraceReader。)

上層

方法

	名稱	說明
	Close	Closes the trace reader and writer. (繼承自 TraceReaderWriter。)
	Dispose	Deletes the trace reader information. (繼承自 TraceReader。)
	Equals	(繼承自 Object。)
	Finalize	(繼承自 Object。)
	GetBoolean	Returns a Boolean value from the record at the specified column position. (繼承自 TraceReader。)
	GetByte	Returns a Byte value from the record at the specified column position. (繼承自 TraceReader。)
	GetBytes	Gets a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset. (繼承自 TraceReader。)
	GetChar	Gets a character value of the specified column. (繼承自 TraceReader。)
	GetChars(Int32, array<Char[], Int32, Int32, Int32)	Gets a character array value from the record at the specified column position. (繼承自 TraceReader。)
	GetChars(Int32, Int64, array<Char[], Int32, Int32)	Gets a character array value from the record at the specified column position. (繼承自 TraceReader。)
	GetData	Returns IDataReader object used when the field points to a remote data structure. (繼承自 TraceReader。)
	GetDataTypeName	Gets the data type of the data value at the specified column position. (繼承自 TraceReader。)
	GetDateTime	Gets a DateTime value of the data value at the specified column position. (繼承自 TraceReader。)
	GetDecimal	Gets a Decimal value of the data value at the specified column position. (繼承自 TraceReader。)
	GetDouble	Gets a floating point value of the data value at the specified column position. (繼承自 TraceReader。)
	GetFieldType	Returns the field type of the data value at the specified column position. (繼承自 TraceReader。)
	GetFloat	Gets a floating point value of the data value at the specified column position. (繼承自 TraceReader。)
	GetGuid	Gets a Guid system value of the data value at the specified column position. (繼承自 TraceReader。)
	GetHashCode	(繼承自 Object。)
	GetInt16	Gets a small integer value of the data value at the specified column position. (繼承自 TraceReader。)
	GetInt32	Gets an integer value of the data value at the specified column position. (繼承自 TraceReader。)
	GetInt64	Gets a long integer value of the data value at the specified column position. (繼承自 TraceReader。)
	GetName	Gets the name of the field at the specified column position. (繼承自 TraceReader。)
	GetOrdinal	Gets the ordinal value of the data value at the specified column position. (繼承自 TraceReader。)
	GetSchemaTable	Gets a table that describes the schema. (繼承自 TraceReader。)
	GetStream	Gets the stream of data. (繼承自 TraceReader。)
	GetString	Gets a String value at the specified column position. (繼承自 TraceReader。)
	GetTimeSpan	Gets a TimeSpan value of the data value at the specified column position. (繼承自 TraceReader。)
	GetType	(繼承自 Object。)
	GetValue	Gets a value of the data value at the specified column position. (繼承自 TraceReader。)
	GetValues	Gets an array of values from the data value at the specified column position. (繼承自 TraceReader。)
	InitializeAsReader	Initializes the specified TraceFile object for reading data from the trace log file.
	InitializeAsReplayOutputWriter	Initializes the specified TraceFile object for writing data to the trace log file only.
	InitializeAsWriter	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	Specifies whether the specified column is set to null. (繼承自 TraceReader。)
	IsNull	Gets a Boolean value that specifies whether value of the data at the specified column position is null. (繼承自 TraceReader。)
	MemberwiseClone	(繼承自 Object。)
	NextResult	Moves to the next result in the trace. (繼承自 TraceReader。)
	Read	Reads the trace record. (繼承自 TraceReader。)
	ToString	(繼承自 Object。)
	TranslateSubclass	Translates the sub class. (繼承自 TraceReader。)
	Write	Writes the trace to the trace file or the trace table. (繼承自 TraceReaderWriter。)

上層

事件

	名稱	說明
	WriteNotify	Raises an event when the trace is written to the trace file or trace table. (繼承自 TraceReaderWriter。)

上層

欄位

	名稱	說明
	currentRow	Specifies the current row. (繼承自 TraceReader。)

上層

備註

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 SQL Server Profiler 參考 or using a set of Transact-SQL stored procedures called SQL 追蹤簡介.

範例

Readme_Tracer

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Management.Trace 命名空間

其他資源

追蹤旗標 (Transact-SQL)

SQL Server Profiler 範本和權限