Results 1 to 2 of 2

Thread: How do we know if the trigger is 'on' or 'off' on a table?

  1. #1
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80

    How do we know if the trigger is 'on' or 'off' on a table?

    Any idea where to look for?
    thanks,

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Try this:

    select name, objectproperty(id,'ExecIsTriggerDisabled') as disabledTrigger
    from sysobjects where objectproperty(id, 'isTrigger') = 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •