DISABLE TRIGGER

Disable a trigger.

Syntax
      DISABLE TRIGGER { [schema.] trigger [,...n ] | ALL }
         ON { object_name | DATABASE | ALL SERVER } [ ; ]

Key:
   object_name - The table or view on which the trigger was created to execute. 
   DATABASE    - The DDL trigger applies to the current database.
   ALL SERVER  - The DDL trigger applies to the current server.

Specifying DISABLE... ALL in a database that is published for merge replication will disable the merge triggers created by SQL Server, and will disrupt replication.

Example

DISABLE TRIGGER MySchema.MyTrigger1 ON MySchema.MyTable;
DISABLE TRIGGER MyTrigger2 ON DATABASE;
GO

# When they kick at your front door, How you gonna come?
With your hands on your head, Or on the trigger of your gun # - The Clash, London Calling (The Guns Of Brixton)

Related commands:

ENABLE TRIGGER
ALTER TRIGGER
sys.triggers
sp_settriggerorder
CREATE TABLE
COLUMNS_UPDATED
TRIGGER_NESTLEVEL
EVENTDATA
Equivalent Oracle command: ALTER TRIGGER...DISABLE