Monica Rathbun needed to rename a table in a lot of scripts. Here’s how she did it:
The quick answer that I came up with is to script out all of the stored procedures into a single query window. This can be done easily through the GUI. Once that is complete, I can easily do a “Find & Replace” on the table name and we’re done!
Ideally, those stored procedures are in source control already and you do your find-and-replace there, but sometimes you can’t control that.