Changes to synonyms are not detected
We use synonyms when accessing data through linked servers. If the synonym is changed to use a new linked server Source Control does not detect that change.
3
votes

See comment for how to enable the requested behaviour.
-
AdminJames Billings (Admin, Redgate) commented
By default we ignore these, but if you go to the setup tab in SQL Source Control, and click "Comparison Options" you should be able to deselect the "Database and Server Name in Synonyms" option.
This should then let it detect the changes you're making.