What are the challenges you face when working across database platforms? Take the survey

Smart Re-name Merge Statement

SqlDev85SqlDev85 Posts: 3 New member

I have been a huge fan of the smart re-name feature within SSMS. I believe there is an issue though with it. I went to use it and it was not picking up one of my dependent stored procedures and the reason is because I was using a merge statement. Does anyone know if Smart re-name does work with merge statements? I know it will not work with dynamic SQL. I am guessing this is an over site. Besides that I love feature!


  • Options
    James RJames R Posts: 104 Silver 4
    Hi @SqlDev85 ,

    Thanks for your post,

    If possible can we have some more information to help us reproduce this issue? An example creation script for the stored procedure / object you're renaming would be great for example.

    Software Engineer
    Redgate Software
  • Options
    SqlDev85SqlDev85 Posts: 3 New member
    Hello James,

    Sorry for not replying sooner! I never saw you replied to my post. My fault.

    I just re-looked at this issue and it seems to be fixed! It must have been fixed in one of the recent updates. Good news. Thanks for getting back to me and sorry I am late in my reply.


Sign In or Register to comment.