title: How do I find Stored Procedures with wrong text in syscomments
body: <p>There appears to be several stored procedures that were renamed with sp_rename, causing the syscomments to be left with the old proc name instead of the new proc name.</p>
  
  <p>Thus, my db transfers are failing to transfer correctly.</p>
  
  <p>Is there a way to find which procs (or any objects) have their names out of synch?</p>
  
  <p>Or better, a simple way to find AND fix them?</p>