Home Forums SQL Server 2005 SQL Server 2005 General Discussion Need to get list of disable and enable triggers from server RE: Need to get list of disable and enable triggers from server

  • December 7, 2009 at 12:56 am

    #1088395

    Another way would be this!

    select CASE OBJECTPROPERTY(OBJECT_ID(name), 'ExecIsTriggerDisabled')

    WHEN 1 THEN 'Disabled'

    ELSE 'Enabled' END as Status

    from sysobjects o

    where o.type='TR'

    ---------------------------------------------------------------------------------