In addition to what Gail said, here is a simple script to Read from the default trace

DECLARE @path NVARCHAR(260);

SELECT @path = REVERSE(SUBSTRING(REVERSE([path]),

CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'

FROM sys.traces WHERE is_default = 1;

SELECT *

FROM ::fn_trace_gettable(@path,DEFAULT)