Listing 1: Code to Return the Information Captured by the Default Trace
SELECT * 
FROM fn_trace_gettable
(N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default)
GO