Views:
Question:
How can I check the DWData database for triggers?

Answer:
By product design, any database triggers within DWData are not supported as they can be known to cause problems within the database or when upgrading DocuWare. If you suspect there are some existing in the Database, please run the following query:
Note: This query would be applicable to MSSQL databases ONLY.
 
Use Dwdata;
SELECT  table_name = OBJECT_NAME(parent_object_id) ,
        trigger_name = name ,
        trigger_owner = USER_NAME(schema_id) ,
        OBJECTPROPERTY(object_id, 'ExecIsUpdateTrigger') AS isupdate ,
        OBJECTPROPERTY(object_id, 'ExecIsDeleteTrigger') AS isdelete ,
        OBJECTPROPERTY(object_id, 'ExecIsInsertTrigger') AS isinsert ,
        OBJECTPROPERTY(object_id, 'ExecIsAfterTrigger') AS isafter ,
        OBJECTPROPERTY(object_id, 'ExecIsInsteadOfTrigger') AS isinsteadof ,
        CASE OBJECTPROPERTY(object_id, 'ExecIsTriggerDisabled')
          WHEN 1 THEN 'Disabled'
          ELSE 'Enabled'
        END AS status
FROM    sys.objects
WHERE   type = 'TR'
ORDER BY OBJECT_NAME(parent_object_id)
 
Once the query has run, the result will display which tables have triggers created and if they are Enabled.

 
KBA is applicable to On-premise Organizations ONLY.
This article is valid for DocuWare versions: 7.1, 7.2, 7.3, 7.4, 7.5, 7.6, 7.7, 7.8, 7.9, 7.10, 7.11, Database triggers, DWData