how to find a trigger is enabled or disabled for a particular table

[smjp]

In sql server 2000 how to find wheather a trigger is enabled or disabled for a particular table... I found that there is stored procedure sp_helptrigger tablename for getting the details of how many triggers present in a particular table... But i want to find out find wheather a trigger is enabled or disabled for a particular table... plz help me out

this is smjp

[Ware Work]

As I understand it triggers are enabled if they exist. You disable it by removing it. It might not fire if there was an error in original command or prior triggers run (multiple can run for same sql statement).

Thanks, Ware