Article Details
Id:18437
Product:finPOWER Connect
Type:NEW
Version:3.04.01
Opened:29/07/2021
Closed:30/07/2021
Released:31/08/2021
Job: J027106

SQL Server; Additional warnings added if Database has Triggers

SQL Server includes the ability to add Triggers to database tables.

However, you MUST NEVER modify the database schema, including triggers, without the express written permission of Intersoft Systems.

NOTE: It is unlikely Intersoft Systems will grant permission for a User to add a Trigger, as these can adversely affect performance and in some cases cause finPOWER Connect to crash and leave the database in a corrupt state.

The following changes have been made to highlight if the Database includes triggers:

  • Support Information includes:
    • Under Database Information section:
      • Warning "Database includes TRIGGERS."
    • Under Database Table Information section:
      • New column that displays any warning message for the Table, in the case "Table has Triggers".
  • Database Documenter:
    • Includes "Triggers" section for each table that has Triggers.