TraceTable.InitializeAsWriter Method

Initializes the specified TraceTable object for reading trace data from a TraceReader object, analyzing the data, and writing data to the referenced trace table.

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

Syntax

'Declaration
Public Sub InitializeAsWriter ( _
    source As TraceReader, _
    serverConnInfo As ConnectionInfoBase, _
    destinationTableName As String _
)
'Usage
Dim instance As TraceTable 
Dim source As TraceReader 
Dim serverConnInfo As ConnectionInfoBase 
Dim destinationTableName As String

instance.InitializeAsWriter(source, serverConnInfo, _
    destinationTableName)

public void InitializeAsWriter(
    TraceReader source,
    ConnectionInfoBase serverConnInfo,
    string destinationTableName
)

public:
void InitializeAsWriter(
    TraceReader^ source, 
    ConnectionInfoBase^ serverConnInfo, 
    String^ destinationTableName
)

member InitializeAsWriter : 
        source:TraceReader * 
        serverConnInfo:ConnectionInfoBase * 
        destinationTableName:string -> unit

public function InitializeAsWriter(
    source : TraceReader, 
    serverConnInfo : ConnectionInfoBase, 
    destinationTableName : String
)

Parameters

• source
  Type: Microsoft.SqlServer.Management.Trace.TraceReader
  A TraceReader object value that specifies the source of the trace data. This object can represent a trace table or a trace file.

• serverConnInfo
  Type: Microsoft.SqlServer.Management.Common.ConnectionInfoBase
  A SqlConnectionInfo object value that specifies the information required to establish a connection with the instance of Microsoft SQL Server that contains the trace table.

• destinationTableName
  Type: System.String
  A String value that specifies the name of the trace table to write the replay trace output data.

Examples

Readme_Tracer

See Also

Reference

TraceTable Class

Microsoft.SqlServer.Management.Trace Namespace

Other Resources

Trace Flags (Transact-SQL)

SQL Server Profiler Templates and Permissions