"Script as INSERT", "Copy as", "Open In Excel" only available in SSMS 18.11.1 but not in VS 16.11.11

JoeSchmoe007

I have the latest version of SQL Prompt installed (10.11.7.28287).

"Script as INSERT", "Copy as", "Open In Excel" only available in SSMS 18.11.1 but not in VS 16.11.11

SQL Prompt Release notes for the latest version said that that there was a fix for that in it but these right-click menu items are still not available in VS.

If I can help troubleshoot it further please let me know because these are the features I use VERY OFTEN. I am C#/SQL Server developer and do everything in Visual Studio, never really use SSMS (have no need).

ostandage

Hi @JoeSchmoe007

Please upgrade to v10.11.9 (10.11.8 has contains a crash) https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.9.27382.exe

Thanks,

Owen

JoeSchmoe007

To clarify: I initially installed the version previous to the latest and then upgraded to the latest when prompted.

ostandage

Hi @JoeSchmoe007

We've put in an additional fix, which should fix the issues you're experiencing. This will ship in the next release, which should be in a couple days.

Thanks,

Owen

JoeSchmoe007

Is that the one released today? I just received notification for 10.11.8.27379

JoeSchmoe007

ostandage said:

Hi @JoeSchmoe007

Please upgrade to v10.11.9 (10.11.8 has contains a crash) https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.9.27382.exe

Thanks,

Owen

This fixed an issue for me. "Script as INSERT", "Copy as", "Open In Excel" are now available in Visual Studio 2019 and 2022. I am not observing any crashes at this time.