Listing 1: Setting Up a Trace

DECLARE @traceID int
DECLARE @maxfilesize bigint
DECLARE @on bit
set @maxfilesize = 5 
set @on = 1
EXEC sp_trace_create @TraceID OUTPUT, 6, N'\\Server\Share\Trace\AuditTrace.trc', @MaxFileSize, 
NULL
EXEC sp_trace_setevent @TraceID, 109, 7, @on