ms sql server 開啟和關閉 trigger

啟用 trigger:

    
ENABLE TRIGGER trigger_name ON table_name;
    

停用 trigger:

    
DISABLE TRIGGER trigger_name ON table_name;
    

刪除 trigger:

    
DROP TRIGGER trigger_name
    

參考資料：
Microsoft.Learn - DISABLE TRIGGER
Microsoft.Learn - ENABLE TRIGGER
Microsoft.Learn - DROP TRIGGER