Stored procedures and triggers are automatically recompiled if SQL replication settings have changed 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 runtime |
Automatically recompile stored procedure or trigger |
|---|---|---|
Off |
On |
Yes |
On |
Off |
No |
