How to find all Database Triggers in HEAT Help Desk

Version 1

    Details

    What is the SQL query to find all the Triggers in a database?


    Resolution

    Run the following query in SQL Management Studio replacing the DB_Name with the name of your database:

    USE DB_Name

    SELECT NAME FROM SYSOBJECTS WHERE XTYPE='TR'