Occasionally it is necessary to verify if there are triggers implemented on a GoldMine database.
Here are 2 methods to verify if and which triggers are in a database.
- In SQL Management Studio open a Query Pane
- Select the GoldMine database from the database drop-down menu.
- Paste one of the following queries into the query pane
- Execute the query
select so.name, so2.name as [table]
from sysobjects so
join sysobjects so2 on so.parent_obj = so2.id
and so.xtype = 'tr'
This will provide an output like below
Execute 'sp_helptrigger' for each table in the current database:
sp_msforeachtable "print '?' exec sp_helptrigger '?'"
This gives an output like the one shown below: