Home Forums SQL Server 7,2000 General Disable and enable trigger RE: Disable and enable trigger

  • January 22, 2009 at 11:58 pm

    #931651

    IN SQL-2000

    To disable / enable selective triggers...

    ALTER TABLE tableName DISABLE TRIGGER triggername

    ALTER TABLE tableName ENABLE TRIGGER triggername

    To disable / enable all triggers...

    ALTER TABLE tableName DISABLE TRIGGER ALL

    ALTER TABLE tableName ENABLE TRIGGER ALL

    *******************

    IN SQL-2005

    To disable / enable selective triggers...

    DISABLE TRIGGER triggername ON tableName

    ENABLE TRIGGER triggername ON tableName

    To disable / enable all triggers...

    DISABLE TRIGGER ALL ON tableName [optional:All server]

    ENABLE TRIGGER ALL ON tableName [optional:All server]