title: Old name of the procedure in sp_helptext
body: <p>Some time ago the procedure <code>ALF_GetPopulationForPolygon_2_old</code> was created. Then in SSMS, it was renamed <code>(right mouse button -&gt; rename)</code> to the procedure <code>ALF_GetPopulationForPolygon_2_old_FOR_DELETE_20170504</code>. Renaming passed normally, but as a result, the query:</p>
  
  <pre><code>SELECT
      sm.definition
  FROM
      sys.objects AS o
          INNER JOIN sys.sql_modules AS sm
          ON ( 1 = 1 )
             AND ( sm.object_id = o.object_id )
  WHERE
      ( 1 = 1 )
      AND ( o.name like 'ALF_GetPopulationForPolygon_2_old_FOR_DELETE_20170504' )
  </code></pre>
  
  <p>And calling the stored procedure:</p>
  
  <pre><code>EXEC sp_helpText 'ALF_GetPopulationForPolygon_2_old_FOR_DELETE_20170504'
  </code></pre>
  
  <p>Return the following text:</p>
  
  <pre><code>...
  CREATE PROCEDURE [dbo]. [ALF_GetPopulationForPolygon_2]
  ...
  </code></pre>
  
  <p>Those show the OLD(!) name of the procedure. Do you have any idea what this is caused, and how can this be fixed?</p>