TraceServer Class
The TraceServer class is a Trace object that represents a new trace on an instance of SQL Server.
Assembly: Microsoft.SqlServer.ConnectionInfoExtended (in Microsoft.SqlServer.ConnectionInfoExtended.dll)
Microsoft.SqlServer.Management.Trace::TraceReader
Microsoft.SqlServer.Management.Trace::TraceServer
| Name | Description | |
|---|---|---|
![]() | TraceServer() | Initializes a new instance of the TraceServer 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.(Inherited from TraceReader.) |
![]() | 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(ConnectionInfoBase^, String^) | Initializes the server as a trace reader. |
![]() | 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.) |
![]() | Pause() | Pauses the trace. |
![]() | Read() | Reads the trace record.(Inherited from TraceReader.) |
![]() | Restart() | Restarts the trace. |
![]() | Stop() | Stops the trace. |
![]() | ToString() | (Inherited from Object.) |
![]() | TranslateSubclass(String^, String^, Int32) | Translates the sub class.(Inherited from TraceReader.) |
| Name | Description | |
|---|---|---|
![]() | currentRow | 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.



