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.