I have a requirement of running the profiler in SQL server 2000 continously till we are able to capture a specific error in the application accessing the database.
We want a script which will keep deleting the trace file (.trc) older than 3 hours to prevent the disk from getting filled up by the trace files.
Please help.