i've managed to stop a new trace file being created by renaming a text
file to the numbering of the next trace file to be created and making
it read only.
I'm not exactly sure how this process is running
but hopefully the problem is fixed and i can ensure the problem is
fixed next time i get a chance to restart the SQL Server service
> >I have used the article below to create the activity trace, but now i
> >cannot stop it.
> >I've removed the scheduled job and tried renaming the sp_blocker_pss80
> >sp and the activity trace file is still being created and i've also
> >tried removing the .ini file.
> >This problem is getting serious.
> >Any ideas on how to stop this ?.
> Have you tried killing the process? Use sp_who2 to get the SPID.
> The other possibility, stop and restart the MSSQLServer service
> (check that you are not disrupting any production activity?)