TraceServer-Klasse

The TraceServer class is a Trace object that represents a new trace on an instance of SQL Server.

Vererbungshierarchie

System.Object
  Microsoft.SqlServer.Management.Trace.TraceReader
    Microsoft.SqlServer.Management.Trace.TraceServer

Namespace:  Microsoft.SqlServer.Management.Trace
Assembly:  Microsoft.SqlServer.ConnectionInfoExtended (in Microsoft.SqlServer.ConnectionInfoExtended.dll)

Syntax

'Declaration
<ComVisibleAttribute(False)> _
Public Class TraceServer _
    Inherits TraceReader
'Usage
Dim instance As TraceServer

[ComVisibleAttribute(false)]
public class TraceServer : TraceReader

[ComVisibleAttribute(false)]
public ref class TraceServer : public TraceReader

[<ComVisibleAttribute(false)>]
type TraceServer =  
    class 
        inherit TraceReader 
    end

public class TraceServer extends TraceReader

Der TraceServer-Typ macht folgende Elemente verfügbar.

Konstruktoren

	Name	Beschreibung
	TraceServer	Initializes a new instance of the TraceServer class.

Zum Anfang

Eigenschaften

	Name	Beschreibung
	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. (Geerbt von TraceReader.)
	Dispose	Deletes the trace reader information. (Geerbt von TraceReader.)
	Equals	(Geerbt von Object.)
	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 the server as a trace reader.
	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.)
	Pause	Pauses the trace.
	Read	Reads the trace record. (Geerbt von TraceReader.)
	Restart	Restarts the trace.
	Stop	Stops the trace.
	ToString	(Geerbt von Object.)
	TranslateSubclass	Translates the sub class. (Geerbt von TraceReader.)

Zum Anfang

Felder

	Name	Beschreibung
	currentRow	Specifies the current row. (Geerbt von TraceReader.)

Zum Anfang

Hinweise

With the TraceServer object you can:

• Start a new trace.

• Read a trace.

In addition to the Trace and Replay objects, the trace can be created manually by using SQL Server Profiler (Referenz) or by using a set of Transact-SQL stored procedures called Einführung in die SQL-Ablaufverfolgung.

Beispiele

Readme_Tracer

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

Andere Ressourcen

Ablaufverfolgungsflags (Transact-SQL)

Vorlagen und Berechtigungen in SQL Server Profiler