Very Computer

by **Stev** » Thu, 03 Apr 2003 02:16:48

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 ?.
Thanks
Regards,
Steve

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271509

by **Steve Thompso** » Thu, 03 Apr 2003 02:45:20

Quote:>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 ?.

>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271509

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?)

Steve

by **Stev** » Fri, 04 Apr 2003 05:13:52

unfortunately this is a production server. cant stop the Service.
i've killed off the processes that i thought were safe, but it just keeps going.
Any more ideas ?

Thanks
Steve

> >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 ?.

> >http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271509

> 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?)

> Steve

by **Stev** » Fri, 04 Apr 2003 07:46:42

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 ?.

> >http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271509

> 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?)

> Steve

Very Computer

How can I stop Activity trace ?

How can I stop Activity trace ?

How can I stop Activity trace ?

How can I stop Activity trace ?

How can I stop Activity trace ?