When i saw *SQL Trace ID 1 was started by login "sa" * in my Error Log I was little surprised. Since i have never started any trace I was wondering what is this all about. Then i came to know that this is the default trace started which is a new feature introduced in SQL Server 2005. Then i was curious about how can i see the contents. here we go...
To See All the Trace and its location :
select * from ::fn_trace_getinfo(default)
To get the File Location
select * from ::fn_trace_getinfo(default) where Property=2
And copy paste the Value column text.
To Get the Trace Data
SELECT * FROM fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default) where starttime>'2007-10-15'