To prevent triggers from running when data arrives through replication, you can add the NOT FOR REPLICATION option to the CREATE TRIGGER or ALTER TRIGGER statements. In this case, the trigger will fire on direct modifications to the base table, but not from subscription actions.
Temporarily, you can disable a trigger to speed up some processes. To do so, you can use the ALTER TABLE statement with the DISABLE TRIGGER option, as in Listing 9.18.
USE Northwind GO -- To disable a single trigger ALTER TABLE Employees DISABLE TRIGGER tr_Employees --, isr_Employees, udt_Employees ...