title: Quickest/Easiest way to use Search/Replace through all stored procedures
body: <p>Actually, this is a 2 part question.</p>
  
  <ol>
  <li><p>Is it possible to use some sort of functionality to search through every stored procedure for a string and possibly replace it, like a standard Find/Replace function?</p></li>
  <li><p>If you have all your stored procedure code include the full database path like this <code>[db1].[dbo].[table1]</code> and you change the database name to <code>[db2]</code> is there a way for SQL Server to automatically update all the code from <code>[db1]</code> tables to <code>[db2]</code>?  Or does it have to be done manually?</p></li>
  </ol>