Smart Rename: Immediate unspecified error when invoked

JR_AUS

Hi Folks,

Wondering if anyone else is experiencing this issue with Smart Rename:

1. Right click on an object in SSMS
2. Select Smart Rename... from the context menu
3. Error

I have reported this error using the in-built tool although have heard nothing from Redgate, hence this post.

SQL Prompt Version: 10.5.3.17209
SSMS Version: 18.8 (although the error occurred in 18.7, too)

I have sys-admin privileges on the server where this error is occurring.

Tianjiao_Li

Hi @JR_AUS

Thanks for your post.

I haven't been able to reproduce the issue oddly. Could you kindly confirm if you have SQL Compare installed on the same machine and its version number?

Did this issue start since you upgraded to 10.5.3.17209 or you had the same issue with the older version of SQL Prompt?

Thanks!

JR_AUS

Hi Tianjiao. Thanks for your response.

Tianjiao_Li said:

Could you kindly confirm if you have SQL Compare installed on the same machine and its version number?

No, I don't have SQL Compare installed on the machine. The only other plugin I have installed is Apex SQL Model [sorry ].

Did this issue start since you upgraded to 10.5.3.17209 or you had the same issue with the older version of SQL Prompt?

No, I had the same issue with the previous version of SQL Prompt.

--Edit--
I just uninstalled Apex SQL Model and the Apex Software Updater...the SQL Prompt Smart Rename feature now works.

Prior to purchasing SQL Prompt I was using a similar Apex product that included a rename feature - it's possible the two clashed.

Jessica R

Thanks for finding that, @JR_AUS!

We have seen issues before when Apex tools reference different versions of the same third-party library (SSMS can only load one version). 

Unfortunately, when this happens the only option is to have one tool installed at a time.