sanket kokane (12/11/2012)
How to modify SP name in Alter Proc script ?
Good question 🙂
I was also thinking upon this. Instructions in the Question should have stated something like this:
Right-click on the procedure name in the object explorer. Select "script procedure as" and Create to new query window. Change the procedure name to 'rename_by_alter'. Execute the script.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter