Hi Joanne,
Thanks for posting this. Future versions of HelpMaster will have a screen to configure the logging options for each of the services. Until then, you can use a database trigger to prevent the record being logged.
Execute the following SQL against your database. This will create a trigger on the tblEmailManagerEventLog table that will bypass all logging except for error logs.
If you would ever like the logging back, you'll need to delete the trigger, or modify it accordingly.
Please note that the Email Manager logs are also recorded in the Windows Event viewer, so even if you use this database trigger approach to block the database level logging, you've always got them there at the Windows level. Windows logging allows you to control many aspects of the log file.
Hope this helps,
Best regards,
Rod
-- Database trigger to disable Email Manager event logging except for errors.
-- SQL Server 2005/2008, HelpMaster v9.1 only
CREATE TRIGGER dbo.tblEmailManagerEventLog_InsertTrigger_OnlyLogErrors
ON dbo.tblEmailManagerEventLog
INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON;
-- Insert statements for trigger here
If (Select LogType From Inserted) > 0 -- All information log information, Errors have a value of 0
Begin
Print 'Event not logged'
End
END