Can you please help me to edit this:

-------------------------------------------------------------------------------------------------------------------------

USE [Audit]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE proc [dbo].[TraceScript]

@DBNamesysname = null

as

set nocount on

declare @rc int

declare @TraceID int

declare @maxfilesize bigint

set @maxfilesize = 5

exec @rc = sp_trace_create @TraceID output, 0, N'InsertFileNameHere', @maxfilesize, NULL

if (@rc != 0) goto error

Changed this to

{ exec @rc = sp_trace_create @TraceID output, 0, N'C:\PWB_Test\AuditTace', @maxfilesize, NULL

if (@rc != 0) goto error

}

declare @on bit

set @on = 1

exec sp_trace_setevent @TraceID, 118, 7, @on

exec sp_trace_setevent @TraceID, 118, 23, @on

exec sp_trace_setevent @TraceID, 118, 8, @on

exec sp_trace_setevent @TraceID, 118, 40, @on

exec sp_trace_setevent @TraceID, 118, 64, @on

exec sp_trace_setevent @TraceID, 118, 1, @on

exec sp_trace_setevent @TraceID, 118, 9, @on

exec sp_trace_setevent @TraceID, 118, 41, @on

exec sp_trace_setevent @TraceID, 118, 49, @on

exec sp_trace_setevent @TraceID, 118, 6, @on

exec sp_trace_setevent @TraceID, 118, 10, @on

exec sp_trace_setevent @TraceID, 118, 14, @on

exec sp_trace_setevent @TraceID, 118, 26, @on

exec sp_trace_setevent @TraceID, 118, 34, @on

exec sp_trace_setevent @TraceID, 118, 50, @on

exec sp_trace_setevent @TraceID, 118, 3, @on

exec sp_trace_setevent @TraceID, 118, 11, @on

exec sp_trace_setevent @TraceID, 118, 35, @on

exec sp_trace_setevent @TraceID, 118, 51, @on

exec sp_trace_setevent @TraceID, 118, 4, @on

exec sp_trace_setevent @TraceID, 118, 12, @on

exec sp_trace_setevent @TraceID, 118, 28, @on

exec sp_trace_setevent @TraceID, 118, 60, @on

exec sp_trace_setevent @TraceID, 118, 5, @on

exec sp_trace_setevent @TraceID, 118, 21, @on

exec sp_trace_setevent @TraceID, 118, 29, @on

exec sp_trace_setevent @TraceID, 118, 37, @on

exec sp_trace_setevent @TraceID, 131, 7, @on

exec sp_trace_setevent @TraceID, 131, 23, @on

exec sp_trace_setevent @TraceID, 131, 8, @on

exec sp_trace_setevent @TraceID, 131, 40, @on

exec sp_trace_setevent @TraceID, 131, 64, @on

exec sp_trace_setevent @TraceID, 131, 1, @on

exec sp_trace_setevent @TraceID, 131, 41, @on

exec sp_trace_setevent @TraceID, 131, 49, @on

exec sp_trace_setevent @TraceID, 131, 6, @on

exec sp_trace_setevent @TraceID, 131, 10, @on

exec sp_trace_setevent @TraceID, 131, 14, @on

exec sp_trace_setevent @TraceID, 131, 26, @on

exec sp_trace_setevent @TraceID, 131, 34, @on

exec sp_trace_setevent @TraceID, 131, 50, @on

exec sp_trace_setevent @TraceID, 131, 3, @on

exec sp_trace_setevent @TraceID, 131, 11, @on

exec sp_trace_setevent @TraceID, 131, 35, @on

exec sp_trace_setevent @TraceID, 131, 51, @on

exec sp_trace_setevent @TraceID, 131, 59, @on

exec sp_trace_setevent @TraceID, 131, 4, @on

exec sp_trace_setevent @TraceID, 131, 12, @on

exec sp_trace_setevent @TraceID, 131, 28, @on

exec sp_trace_setevent @TraceID, 131, 60, @on

exec sp_trace_setevent @TraceID, 131, 21, @on

exec sp_trace_setevent @TraceID, 131, 29, @on

exec sp_trace_setevent @TraceID, 131, 37, @on

-- Set the Filters

declare @intfilter int

declare @bigintfilter bigint

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Server Profiler - de4d310b-cffd-4a87-9da9-d7f9768c9c59'

-- Set the trace status to start

exec sp_trace_setstatus @TraceID, 1

select TraceID=@TraceID

goto finish

error:

select ErrorCode=@rc

finish:

go

------------------------------------------------------------------------------------------------------------------------