Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mohammad Meimandi Potential Issue with Re-Naming Stored Procedures RE: Potential Issue with Re-Naming Stored Procedures

  • October 10, 2010 at 10:24 pm

    #1234770

    Andrew Novick (10/9/2010)

    Yes, it's a problem. I submitted an item on Connect

    https://connect.microsoft.com/SQLServer/feedback/details/398203/sp-rename-doesnt-change-the-text-of-udfs-or-procs-sp-helptext-then-returns-a-script-with-the-old-name

    and it was classified as "Won't Fix"

    It's something we're going to have to live with.

    Regards,

    Andy

    Andrew Novick

    SQL Server MVP

    http://www.NovickSoftware.com

    Thanks author for nice article.

    I many times used sp_rename stored procedure but it is for our testing database. In production work, we always drop/create procedure with Grant so we did not face this issue, but good to know that if we are using 'syscomments' instead of 'sys_modules' anywhere in any script, it cause an issue.

    Thanks