This is what I did.

creation and starting:

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

declare @rc int

declare @TraceID int

declare @maxfilesize bigint

set @maxfilesize = 5

exec @rc = sp_trace_create @TraceID output, 2, N'E:\Traces\monitor', @maxfilesize, NULL

declare @on bit

set @on = 1

exec sp_trace_setevent @TraceID, 54, 1, @on

exec sp_trace_setevent @TraceID, 54, 3, @on

exec sp_trace_setevent @TraceID, 54, 6, @on

exec sp_trace_setevent @TraceID, 54, 9, @on

exec sp_trace_setevent @TraceID, 54, 10, @on

exec sp_trace_setevent @TraceID, 54, 11, @on

exec sp_trace_setevent @TraceID, 54, 12, @on

exec sp_trace_setevent @TraceID, 54, 13, @on

exec sp_trace_setevent @TraceID, 54, 14, @on

exec sp_trace_setevent @TraceID, 54, 16, @on

exec sp_trace_setevent @TraceID, 54, 17, @on

exec sp_trace_setevent @TraceID, 54, 18, @on

declare @intfilter int

declare @bigintfilter bigint

set @intfilter = 8

exec sp_trace_setfilter @TraceID, 3, 1, 0, @intfilter

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'

exec sp_trace_setstatus @TraceID, 1

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

Did some transactions and tried to load data with function:

select * from :: fn_trace_gettable( N'E:\Traces\monitor.trc',default)

output: error, what I mentioned.

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

check the file but size is still o KB.

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

stopped the SQL Server:

check the file, now the size is 128KB.

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

restarted the SQL Server:

run the function again:

got the result.

What's wrong with code?

MCP MCSE MCSD MCDBA