Maybe a silly question... but is there an easy SQL query that will let me know if a given trigger is enabled or disabled?

I'm trying to come up with a script that will produce a report of all the triggers in a database, and I can't figure out how to report whether the trigger is enabled or not. I might as well ask now, but I'll need something similar for Foreign Keys...

Thanks for any help!


MS Sql Server LazyDBA home page