Is a triger enabled?

How can i check if a trigger is enabled for a specific Table, using Enterprise Manager or query the database?
Who is Participating?
brsltdConnect With a Mentor Commented:

I played around with Alter Table to disable and enable a trigger, and one noticeable change on sysobjects was that the status changed to 2328 from 280.  THerefore, if you execute the following in Analyser you can see if it is disabled.

Select Name from sysobjects where type='TR' and Status=2328


This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.  You'll also find a link there for Experts who wish to participate in the cleanup effort of old and abandoned questions.
Thank you,
Moderator @ Experts Exchange
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.