To disable a DML trigger, at a minimum, a user must have ALTER permission on the table or view on which the trigger was created. To disable a DDL trigger with server scope (ON ALL SERVER) or a logon ...
below is a use demo: Connect to SQL Server, create a table dbo.OrderDetail, and run some sql on this table.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results