SQL-Articles
This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.