Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Cleaning the error log...

Cleaning the error log in Dynamics 7.x

(0) Share

Report

Posted on by Gary Sitton

We have Dynamics SL 7.x. The error log has never been cleaned and our entire history is there. We cannot clean/empty it through the application as it freezes.

Can we delete the error log externaly if so what are the tables that need to be cleared.

Thanks

Gary

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Re: Cleaning the error log in Dynamics 7.x

use <application DB>

DELETE FROM pstatus

WHERE execdate < '2011-01-01'

This will leave only this year's events to be deleted thru the SL screen.

Ayrin