I need to updated a stored procedure in each of roughly 1000 schema distributed across 10 databases in MS SQL 2005.
I have the alter procedure t-sql to update one schema. To apply the change to a different schema the procedure name and several calls to other procedures have to be updated with the correct schema. I'm currently doing this with a find and replace from the management studio while testing.
Is there a way to efficiently do this across many schema without manually updating the t-sql each time? If so, please give detail.