SQL Server 2000 Trace Utilities:

• SplitTrc: splits a large SQL Server 2000 trace file, in multiple smaller trace files

• DumpTrc: dumps the content of a SQL Server 2000 trace file as readable ASCII output to the console

• Trc2Sql: saves a SQL Server 2000 trace file as a SQL script

• Trc2Table: saves a SQL Server 2000 trace file to a SQL Server table

• Trc2XML: save a SQL Server 2000 trace file as an XML file

SQL Server 2000 Trace T-SQL scripts, stored procedure, functions etc.

• SQL Server 2000 Trace helper functions (fn_trace_eventname, fn_trace_columnname, fn_trace_comparison_operator, fn_trace_logical_operator)
• SQL Server 2000 Black Box Trace stored procedure

SQL Trace articles and information:

• SQL Server 2000 Trace Event Matrix
• SQL Server 7.0 Trace Event Matrix

Misc. Utilities:

• DTCTest: tool to test enlisting distributed transactions to SQL Server using ODBC or OLE-DB

• BulkXML: command line wrapper around SQLXML - SQLXMLBulkLoad

• ListSQLSvr: enumerate SQL Servers running/available on the network, using the ODBC SQLBrowseConnect API

• EnumSQLSvr: enumerating SQL Server, using the LAN Manager API NetServerEnum()

• OleDbEnum: enumerate SQL Servers, using the SQL Server OLE-DB provider

• SetPF: Change location of Program Files directory

T-SQL scripts, procedure, functions etc.

• sp_waitstats - analyze SQL Server 2000 resource utilization using wait states
• fn_filestats - analyze SQL Server 2000 disk I/O utilization
• fn_setops - decode the SET options in syscacheobjects
• SQL Server 2000 Location Helper Functions
• Wrapper SP for xp_smtp_sendmail, sp_smtp_sendmail

Questions or problems regarding this web site should be directed to Web Master.
Copyright © 1991-2005 SQLDev.Net. All rights reserved.
Last modified: 04/06/05.