Stored procedures and triggers are automatically recompiled if SQL replication settings have change from “off” to “on” between two successive executions of the stored procedure or trigger.
SQL statement replication setting at compile time |
SQL statement replication setting at run time |
Automatically recompile stored procedure/trigger? |
|---|---|---|
Off |
On |
Yes |
On |
Off |
No |
