title: SQL Server 2008 query to search all stored procedure for a specific parameter name
body: <p>I have a column <code>name varchar(8)</code>....I want to change the size to 20 ...and have almost about 100 stored procedures .</p>
  
  <p>I need to change the size of <code>@name</code> in all stored procedures that I have passed name as a parameter.</p>