I have created triggers to track changed data in various fields of several tables. Such triggers work at table level and are attached with table.  Here is syntax to disable and enable trigger TRG_Job_Audit on Job table:

-- Disable the trigger
ALTER TABLE Job DISABLE TRIGGER [TRG_Job_Audit]
GO

-- Enable the trigger
ALTER TABLE Job ENABLE TRIGGER [TRG_Job_Audit]
GO

Same task may be performed very easily through SSMS. Suppose trigger TRG_Job_Audit is created on table Job. And we have to disable and enable it through SSMS

• Open SSMS
• Go to table on which trigger is defined
• Open triggers folder under table

Right click on trigger and click on Disable.  Confirmation dialog will be shown and icon of trigger will be slightly changed showing the change in trigger status.

To enable the trigger through SSMS, again right click on disabled trigger and click Enable.