How to check for Microsoft SQL triggers on the GoldMine database.

Version 1

    Details

     

    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.

     


    Resolution

     

    • 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

     

    Query 1

     

    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

     

     

    Query 2


    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: