Why is exec inserted into the request body?

Question

Delphi

In a Delphi program, the database is accessed via ADOQuery. In one place before the insert had to turn off the trigger. On some computers, everything works fine, but on others, the error "Incorrect syntax near the keyword "trigger"" is displayed, and for some reason the profiler displays that it is trying to execute the instruction. exec disable trigger dbo.<trigger_name>…
What could it be and how to deal with it?

Answer 1

This is related to the MS SQL client version. Several options to rewrite the trigger.

ALTER TABLE table_name DISABLE TRIGGER tr_name
ALTER  TRIGGER trigger_name  DISABLE