I ran a test and noticed that when I used the Smart Rename feature on a table's column name, it only updated stored procedure code that referenced the column in question, if that sp is in the same database. If the sp code resides in another db, it is not updated, even though it references the column being renamed.
I have a "common" database with tables like account, user, customer, season, etc, that are then referenced across all of the other sql dbs on the server. Is there a way to get smart rename to rename a column and include referencing stored procedures from multiple dbs ? A setting to change etc? If not, is this feature in a future versions wish list ?
Our current work around is to run dependency tracker as well (for the table), find all of the hits, comb through them to find dependency hits on that specific column, then hand-edit the code. Its time consuming and not pretty.