TechNet
Export (0) Print
Expand All

TraceServer Class

 

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

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

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

[ComVisibleAttribute(false)]
public class TraceServer : TraceReader

NameDescription
System_CAPS_pubmethodTraceServer()

Initializes a new instance of the TraceServer class.

NameDescription
System_CAPS_pubpropertyDepth

Gets the depth value for the trace reader.(Inherited from TraceReader.)

System_CAPS_pubpropertyFieldCount

Gets the number of columns in the data.(Inherited from TraceReader.)

System_CAPS_pubpropertyIsClosed

Gets the Boolean property value that specifies whether the trace reader is closed.(Inherited from TraceReader.)

System_CAPS_pubpropertyItem[Int32]

Gets the column specified by the index position.(Inherited from TraceReader.)

System_CAPS_pubpropertyItem[String]

Gets the column with the specified name.(Inherited from TraceReader.)

System_CAPS_pubpropertyRecordsAffected

Gets the number of records of data.(Inherited from TraceReader.)

NameDescription
System_CAPS_pubmethodClose()

Closes the trace reader.(Inherited from TraceReader.)

System_CAPS_pubmethodDispose()

Deletes the trace reader information.(Inherited from TraceReader.)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetBoolean(Int32)

Returns a Boolean value from the record at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetByte(Int32)

Returns a Byte value from the record at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetBytes(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.)

System_CAPS_pubmethodGetChar(Int32)

Gets a character value of the specified column.(Inherited from TraceReader.)

System_CAPS_pubmethodGetChars(Int32, Char[], Int32, Int32, Int32)

Gets a character array value from the record at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetChars(Int32, Int64, Char[], Int32, Int32)

Gets a character array value from the record at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetData(Int32)

Returns IDataReader object used when the field points to a remote data structure.(Inherited from TraceReader.)

System_CAPS_pubmethodGetDataTypeName(Int32)

Gets the data type of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetDateTime(Int32)

Gets a DateTime value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetDecimal(Int32)

Gets a Decimal value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetDouble(Int32)

Gets a floating point value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetFieldType(Int32)

Returns the field type of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetFloat(Int32)

Gets a floating point value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetGuid(Int32)

Gets a Guid system value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetInt16(Int32)

Gets a small integer value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetInt32(Int32)

Gets an integer value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetInt64(Int32)

Gets a long integer value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetName(Int32)

Gets the name of the field at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetOrdinal(String)

Gets the ordinal value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetSchemaTable()

Gets a table that describes the schema.(Inherited from TraceReader.)

System_CAPS_pubmethodGetStream(Int32)

Gets the stream of data.(Inherited from TraceReader.)

System_CAPS_pubmethodGetString(Int32)

Gets a String value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetTimeSpan(Int32)

Gets a TimeSpan value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodGetValue(Int32)

Gets a value of the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodGetValues(Object[])

Gets an array of values from the data value at the specified column position.(Inherited from TraceReader.)

System_CAPS_pubmethodInitializeAsReader(ConnectionInfoBase, String)

Initializes the server as a trace reader.

System_CAPS_pubmethodIsDBNull(Int32)

Specifies whether the specified column is set to null. (Inherited from TraceReader.)

System_CAPS_pubmethodIsNull(Int32)

Gets a Boolean value that specifies whether value of the data at the specified column position is null.(Inherited from TraceReader.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodNextResult()

Moves to the next result in the trace.(Inherited from TraceReader.)

System_CAPS_pubmethodPause()

Pauses the trace.

System_CAPS_pubmethodRead()

Reads the trace record.(Inherited from TraceReader.)

System_CAPS_pubmethodRestart()

Restarts the trace.

System_CAPS_pubmethodStop()

Stops the trace.

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodTranslateSubclass(String, String, Int32)

Translates the sub class.(Inherited from TraceReader.)

NameDescription
System_CAPS_protfieldcurrentRow

Specifies the current row.(Inherited from TraceReader.)

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 Using SQL Server Profiler or by 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.

Return to top
Show:
© 2016 Microsoft