Post reply

How can I identify triggers enabled?

  • May 4, 2009 at 7:10 am

    #208958

    How can I identify triggers enabled?

    It is a field of sysobjects that indicates whether the trigger is enabled or there is another table?

  • May 4, 2009 at 7:51 am

    #988088

    You can right click the table in EM, and choose All Tasks > Manage Triggers, and you can see the triggers on your table. Not sure if there is another way.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

  • May 4, 2009 at 9:26 pm

    #988525

    taniaminter (5/4/2009)

    How can I identify triggers enabled?

    It is a field of sysobjects that indicates whether the trigger is enabled or there is another table?

    Hi,

    try this

    use DB

    GO

    IF (OBJECTPROPERTY (object_id('/*Trigger name*/'),'ExecIsTriggerDisabled') = 1)

    PRINT 'Trigger disabled'

    ELSE

    PRINT 'Trigger enabled'

    ARUN SAS

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

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