Changing a data type used in a SP creates problems
When changing a data type used in a SP (e.g. add a new column to it and commit it). getting latest fails on other linked DBs. You have to drop the SP on the target DB.
The weird thing is that sometimes it works, but most of the times it doesn't. Not sure why the behavior is not the same all of the times...
Kostas shared this idea