Another lesson not learned about reading the question and answers carefully.
You can obtain info by querying sys.triggers but they are only stored as objects on the master database. I got too excited and chose true/true... oops!
I'll call this karma... 😉
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]