DumpTrc.exe - Dump SQL Trace File

version: 1.0.0.1
last updated: 13 April 2005
platform: MSDE 2000 and SQL Server 2000 running Windows NT 4.0 and higher

Description:

DumpTrc, dumps the content of a SQL Server 2000 trace file to the console or ASCII output file. The console out can be redirected like all normal output to STDOUT; for example you can page the output using DumpTrc -i c:\trace.trc | MORE

Usage:

DumpTrc.exe version 1.0x1

DumpTrc usage:

-i input file
-o output file

-v version information
-? command line usage

Sample output:

Dump the content of a SQL Server 2000 trace file to the console.

DumpTrc.exe -i c:\temp\trace.trc

Output:

Event: 0 TraceStart
Column: StartTime Data: 2005-04-11 16:14:01.273
Column: EventClass Data: 0
Event: 17 ExistingConnection
Column: TextData Data: -- network protocol: LPC
set quoted_identifier on
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7

Column: NTUserName Data: SYSTEM
Column: ClientProcessID Data: 444
Column: ApplicationName Data: Entegra 2.3.2
Column: LoginName Data: NT AUTHORITY\SYSTEM
Column: SPID Data: 51
Column: EventClass Data: 17

Etc.

Dump the content of a SQL Server 2000 trace file to an ASCII output file.

DumpTrc.exe -i c:\temp\trace.trc -o c:\temp\trace.txt

Installation:

Simply copy "DumpTrc.exe" onto your machine; preferred location is the "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" directory, but it can be installed in any directory, as long as the "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" direct is on the PATH.

Download: DumpTrc.zip

Requirements:

The SQL Server 2000 client tools need to be installed.
The "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" needs to be on the PATH (default when SQL Server 2000 Client Tools are installed)

Planned functionality enhancements:

None
Other suggestions, ideas, please send email to ideas