Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
The TraceTable class is a Trace object that represents a table of trace information.
Vererbungshierarchie
System.Object
Microsoft.SqlServer.Management.Trace.TraceReader
Microsoft.SqlServer.Management.Trace.TraceReaderWriter
Microsoft.SqlServer.Management.Trace.TraceTable
Namespace: Microsoft.SqlServer.Management.Trace
Assembly: Microsoft.SqlServer.ConnectionInfoExtended (in Microsoft.SqlServer.ConnectionInfoExtended.dll)
Syntax
'Declaration
<ComVisibleAttribute(False)> _
Public Class TraceTable _
Inherits TraceReaderWriter
'Usage
Dim instance As TraceTable
[ComVisibleAttribute(false)]
public class TraceTable : TraceReaderWriter
[ComVisibleAttribute(false)]
public ref class TraceTable : public TraceReaderWriter
[<ComVisibleAttribute(false)>]
type TraceTable =
class
inherit TraceReaderWriter
end
public class TraceTable extends TraceReaderWriter
Der TraceTable-Typ macht folgende Elemente verfügbar.
Konstruktoren
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Methode") |
TraceTable | Initializes a new instance of the TraceTable class. |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Eigenschaft") |
Depth | Gets the depth value for the trace reader. (Geerbt von TraceReader.) |
|
FieldCount | Gets the number of columns in the data. (Geerbt von TraceReader.) |
|
IsClosed | Gets the Boolean property value that specifies whether the trace reader is closed. (Geerbt von TraceReader.) |
|
Item[Int32] | Gets the column specified by the index position. (Geerbt von TraceReader.) |
|
Item[String] | Gets the column with the specified name. (Geerbt von TraceReader.) |
|
RecordsAffected | Gets the number of records of data. (Geerbt von TraceReader.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
|
Close | Closes the trace reader and writer. (Geerbt von TraceReaderWriter.) |
|
Dispose | Deletes the trace reader information. (Geerbt von TraceReader.) |
|
Equals | (Geerbt von Object.) |
.gif "Geschützte Methode") |
Finalize | (Geerbt von Object.) |
|
GetBoolean | Returns a Boolean value from the record at the specified column position. (Geerbt von TraceReader.) |
|
GetByte | Returns a Byte value from the record at the specified column position. (Geerbt von TraceReader.) |
|
GetBytes | Gets a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset. (Geerbt von TraceReader.) |
|
GetChar | Gets a character value of the specified column. (Geerbt von TraceReader.) |
|
GetChars(Int32, array<Char[], Int32, Int32, Int32) | Gets a character array value from the record at the specified column position. (Geerbt von TraceReader.) |
|
GetChars(Int32, Int64, array<Char[], Int32, Int32) | Gets a character array value from the record at the specified column position. (Geerbt von TraceReader.) |
|
GetData | Returns IDataReader object used when the field points to a remote data structure. (Geerbt von TraceReader.) |
|
GetDataTypeName | Gets the data type of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetDateTime | Gets a DateTime value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetDecimal | Gets a Decimal value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetDouble | Gets a floating point value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetFieldType | Returns the field type of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetFloat | Gets a floating point value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetGuid | Gets a Guid system value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetHashCode | (Geerbt von Object.) |
|
GetInt16 | Gets a small integer value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetInt32 | Gets an integer value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetInt64 | Gets a long integer value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetName | Gets the name of the field at the specified column position. (Geerbt von TraceReader.) |
|
GetOrdinal | Gets the ordinal value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetSchemaTable | Gets a table that describes the schema. (Geerbt von TraceReader.) |
|
GetStream | Gets the stream of data. (Geerbt von TraceReader.) |
|
GetString | Gets a String value at the specified column position. (Geerbt von TraceReader.) |
|
GetTimeSpan | Gets a TimeSpan value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetType | (Geerbt von Object.) |
|
GetValue | Gets a value of the data value at the specified column position. (Geerbt von TraceReader.) |
|
GetValues | Gets an array of values from the data value at the specified column position. (Geerbt von TraceReader.) |
|
InitializeAsReader | Initializes a new instance of the TraceTable class for reading trace data. |
|
InitializeAsReplayOutputWriter | Initializes a new instance of the TraceTable class for writing replay trace information. |
|
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. |
|
IsDBNull | Specifies whether the specified column is set to null. (Geerbt von TraceReader.) |
|
IsNull | Gets a Boolean value that specifies whether value of the data at the specified column position is null. (Geerbt von TraceReader.) |
|
MemberwiseClone | (Geerbt von Object.) |
|
NextResult | Moves to the next result in the trace. (Geerbt von TraceReader.) |
|
Read | Reads the trace record. (Geerbt von TraceReader.) |
|
ToString | (Geerbt von Object.) |
|
TranslateSubclass | Translates the sub class. (Geerbt von TraceReader.) |
|
Write | Writes the trace to the trace file or the trace table. (Geerbt von TraceReaderWriter.) |
Zum Anfang
Ereignisse
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliches Ereignis") |
WriteNotify | Raises an event when the trace is written to the trace file or trace table. (Geerbt von TraceReaderWriter.) |
Zum Anfang
Felder
| Name | Beschreibung | |
|---|---|---|
.gif "Geschütztes Feld") |
currentRow | Specifies the current row. (Geerbt von TraceReader.) |
Zum Anfang
Hinweise
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 (Referenz) or using a set of Transact-SQL stored procedures called Einführung in die SQL-Ablaufverfolgung.
Beispiele
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
Siehe auch
Verweis
Microsoft.SqlServer.Management.Trace-Namespace