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 6, 2010 at 11:55 pm

    #1233264

    This is bound to happen.

    Per BOL (http://msdn.microsoft.com/en-us/library/ms188351.aspx):

    Changing any part of an object name can break scripts and stored procedures. We recommend you do not use this statement to rename stored procedures, triggers, user-defined functions, or views; instead, drop the object and re-create it with the new name.

    Please always drop & recreate stored procedures.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins