Created On:  21 October 2010

Problem:

What is the best process for clearing out the activity log for Modernization Workbench when using a SQL Server repository?

Resolution:

The following query may be used to clean the activity log for SQL Server repositories:

CREATE OR REPLACE PROCEDURE Anchor1.DelActivityLog() 

as

begin

   DELETE FROM ActivityLog

   WHERE "ID" NOT IN

      (SELECT DISTINCT "LogRef"

       FROM ActivityLogRecent);  

       Commit;

      EXCEPTION WHEN OTHERS THEN NULL;   



end;
Incident #2473671