SQL Server Performance Forum – Threads Archive

Trigers Enable or Disble

Is there any way of getting the list of triggers WITH THE status of it (Enable or Disable)
I checked ofr sys.obejcts and sp_helptriggers but couldn’t find it. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

got it
status = CASE WHEN OBJECTPROPERTY (id, ‘ExecIsTriggerDisabled’) = 0
THEN ‘Enabled’ ELSE ‘Disabled’ END,
—————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

you can query Sys.Triggers table also select *from sys.triggers where is_disabled=1 –list the triggers disabled Madhu

---

that will be more easy. thanks —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

]]>