You will get a trace id when you create a trace using sp_trace_create.

Another way is to query the existing traces using fn_trace_getinfo.

You might find my following article useful:
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


[quoted text, click to view]

Hello Victor

You may find it helpful (for learning purposes) to first create the trace
in Profiler and then script it out. This creates an almost functional SQL
script that you can open in SQL Query Analyzer. Just change the target
filename and you should be good to run the script and see how it works.

Thank you for using Microsoft newsgroups.

Sincerely

Pankaj Agarwal
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.