Smart Re-name Merge Statement
SqlDev85
Posts: 3 New member
in SQL Prompt
Hello,
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!
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!
Tagged:
Comments
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.
Regards,
James
Redgate Software
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.
-Robert