USE [ION_SystemLog]
Delete From EventID
Delete From EventException
Delete From Event
Delete From Diagnostic
-- Add an even in the ION_SystemEventLog about truncating it
DECLARE	@return_value int,
		@newID int,
		@timestamp datetime,
		@computer nvarchar (100)
SET @timestamp = (SELECT GETUTCDATE());
SET @computer = (SELECT HOST_NAME());

EXEC	@return_value = [dbo].[spSL_Event_Add]
		@aTimestamp = @timestamp,
		@aPriority = 192,
		@aSource = N'Configuration Manager Tool',
		@aSourceType = NULL,
		@aTarget = NULL,
		@aCategory = 100,
		@aComputer = @computer, 
		@aDescription = N'The Event Log was truncated by CM Tool',
		@newID = @newID OUTPUT