Triggers in SQL

In SQL server you can list all the triggers in a database using the following query:

SELECT * FROM sysobjects WHERE xType = 'TR';

You can run this code in query analyzer.