Old name of the procedure in sp_helptext

Question

Some time ago the procedure ALF_GetPopulationForPolygon_2_old was created. Then in SSMS, it was renamed (right mouse button -> rename) to the procedure ALF_GetPopulationForPolygon_2_old_FOR_DELETE_20170504. Renaming passed normally, but as a result, the query:

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' )

And calling the stored procedure:

EXEC sp_helpText 'ALF_GetPopulationForPolygon_2_old_FOR_DELETE_20170504'

Return the following text:

...
CREATE PROCEDURE [dbo]. [ALF_GetPopulationForPolygon_2]
...

Those show the OLD(!) name of the procedure. Do you have any idea what this is caused, and how can this be fixed?

Old name of the procedure in sp_helptext

1 Answers