Post reply

Indication of whether triggers are enabled/disable

  • December 15, 2003 at 3:53 am

    #83597

    Hi all

    I am looking for an indication of whether a trigger or all triggers for a table are enabled or disabled.

    I am using Alter Table to enable and disable them.

    I cannot find any system table, system stored proc or information_schema that indicates whether they are enabled or disabled.

    I would like to be able to test for their state in a statement, so I can act upon the result.

    Does anyone have any ideas.

    Many Thanks

    David

  • December 15, 2003 at 4:06 am

    #486126

    Sorry, can't help you with an example, because I don't use triggers anymore, but there is an OBJECTPROPERTY 'ExecIsTriggerDisabled'.

    It returns 1 when trigger is disabled, 0 when trigger is not disabled.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 15, 2003 at 4:12 am

    #486128

    Thanks Frank, just what I was after.

    Cheers

    David

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply