title: Mass change datatype and rename of dependent store procedure variables
body: <p>I am in the process of optimising my database and I was thinking of changing the datatype for some columns from DATETIME to SMALLDATETIME on my tables.</p>
  
  <p>Is there a system stored procedure that returns both the contents/code of a store procedure and the dependent table which will then allow me to do a join on a filtered list of tables?</p>
  
  <p>Cheers!</p>
  
  <p>EDIT1:</p>
  
  <p>Im looking to programatically rename the stored procedures not track dependencies!</p>