It's a familiar problem... The business requests a column of say size 50 characters. A few years later they need that to fit more information and ask the column to become say size 100 characters. So, we make the column 100, easy. Now, we need to modify say 30 Stored Procedures. Because all the temp tables, variables and parameters relating to that column also need to be changed from 50 to 100.
Just wondered how others deal with this?
I was wondering about implementing a policy: whatever the business asks for, we multiply it by 5.