I defined a Trigger, which use a synonym (Table) on the other server, because the network problems now synonymous with failure,
Excuse me,
Now change Table, without triggering does not meet the conditions, this will Trigger a recompile? Will an error?

CodePudding user response:

Modify the table structure, or a table data?

CodePudding user response:

Don't trigger, the trigger won't be recompiled, also won't complain!

CodePudding user response:

reference 1st floor qq646748739 response:

modify the table structure, or table data?

Modify the table data!
To find information on the Internet before said, if a synonym for failure, recompiling, I'd like to know does not meet the trigger condition, will compile?

CodePudding user response:

Triggers only if meet the conditions of trigger,
If a synonym for failure, need you manual recompilation,
The Trigger itself does not automatically compile, because there is no Trigger, so also won't complain,