Execute the following script in Query Editor to disable an active trigger:

ALTER TABLE TableName DISABLE TRIGGER TriggerName;
GO