Hey

If you didn't remove the line:

DECLARE @TraceID INT;

You are declaring it, so I would check for misspellings, left out lines, or if you do a GO inbetween

/Jon

DBA_Learner (9/12/2012)

---

I am following...

Awesome!

Thanks a lot, that works great 🙂

/Jon

Hey

I am getting an error on adding the event

DECLARE @return_code INT;

DECLARE @TraceID INT;

DECLARE @maxfilesize BIGINT;

SET @maxfilesize = 5;

--step 1: create a new empty trace definition

EXEC sp_trace_create

...