INF: How to Create a SQL Server 2000 Trace - Microsoft Support

This stored procedure is an alternative to using SQL Profiler to create a script to create a trace.

support.microsoft.com