Symptom Unable to configure the Microsoft SQL Server Trigger Agent from the TaskCentre Configurator tool as it does not detect the OLE Automation flag from the database. The Configurator log shows the…

Symptom Unable to run an SQL Server trigger, the following error message is received: SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component ‘Ole Automation Procedures’ because this component is turned off…

Symptom An SQL Server trigger has been created on a database table but when the table is modified the task is not triggered to run. The Windows Event Viewer log on the…

Symptom Within the Configurator, the SQL Agent instance prerequisites screen displays the following error: SQL Instance Not Connectable The Configurator prompts for credentials but fails to clear the error, no matter what…

Permissions to Create or Delete a trigger Before you can work with triggers from the Microsoft SQL Server Trigger tool, you must have the following permissions to create or delete the trigger:…

Symptom The TaskCentre event log shows multiple 0x80040205 errors. The source of the error is IWClTcp.ITCAPISession. Cause Normally when a task that contains a SQL trigger is deleted, the corresponding trigger is…

Symptom The Windows application event log shows Access Denied (-214724891) when firing a TaskCentre SQL agent trigger. This occurs when a trigger is fired using SQL Server 2005 or higher. The following…

Symptom Tasks triggered by the SQL trigger agent do not run and the TaskCentre event log records the following error code: 0x80037000 Cause This error occurs because by default versions of SQL…