Triggers can be disabled and enabled using the system procedures sp_DisableTriggers and sp_EnableTriggers. Changes to the disabled state of triggers take place immediately. Triggers can be disabled or enabled for the current user (connection), all database users, a single table, or a single trigger.
All triggers are disabled/enabled on the connection which made the request. This setting will not affect other connections made by the same database user. This setting is not persisted after the user disconnects.
All Database Users
All triggers for all users of the current database are disabled/enabled. This setting is persisted.
All triggers associated with a single table are disabled/enabled. This setting affects all database users and is persisted.
A single trigger of a single table is disabled/enabled. This setting affects all database users and is persisted.