Installing SSMSExecutor on Newer Versions

[manngo]

I have something that works for me. I’ve tried with new installations of both SSMS 19 and SSMS 20. It involves unzipping the Zip package and putting it directly in the SSMS Extensions folder

1. Download the zip file from:

   https://github.com/devvcat/ssms-executor/releases/download/v2.0.3-alpha/SSMSExecutor-2.0.3-alpha.zip

   You may have an issue with the downloaded the file. Your browser or Windows may not trust the file, so you should unblock the ZIP file after downloading:

   • Right-Click on the ZIP file and select Properties
   • Near the bottom select Unblock

2. Unzip the file as SSMSExecutor

   and put the SSMSExecutor folder into the following folder:

   • C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\

   For SSMS 19, it’s

   • C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions\

This assumes a normal installation of SSMS. In any case, find the corresponding Extensions folder and put the SSMSExecutor folder inside.

Update

I have created a simple installer using AutoIT. It’s digitally signed, but you may get a few trust warnings. I includes the content of the ZIP file.

Instructions:

1. You need to have administrator rights on your computer, since it’s installing in a protected folder. It should ask for permission any way, but, if that fails, you can try Right-Click and Run as Administrator.

2. You’ll see a list of four possible versions. I think I’ve got the install locations right, but we’ll see. Check one or more existing versions.

   • If there’s no such folder on your system, you’ll see a question mark after the version label. You can try your luck anyway, but I doubt you’d get anywhere.
   • If the addon has already been installed, the version label will be in bold.

If somehow you’ve got a version in a non-standard location, you can create an ini file called install.ini, and put the file in the same location as the installer.

The ini file should look something like this:

[Install]
;   Label = Location
    Test SSMS = C:\Users\username\Desktop\SSMSExecutor

;   C: SSMS 17 = C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions\SSMSExecutor\
;   C: SSMS 18 = C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\SSMSExecutor\
;   C: SSMS 19 = C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions\SSMSExecutor\
;   C: SSMS 20 = C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\SSMSExecutor\

You’ll see the additional items when you next start the installer. For testing purposes, you can try the test one above, but remember to include your own username, of course.

It’s still very rough. I would welcome any suggestions and bug reports.

E&OE. Share & Enjoy. This package does what it does and doesn’t do what it doesn’t. Handle with Care. Your Mileage May Vary. Not to be Consumed. This Space for Rent. Disney Comics Are Good Comics.

ssms-executor-installer.zip

[SteveRam007]

Is there any plan for the new version SSMS 20.0

[manngo]

Is there any plan for the new version SSMS 20.0

I’ve added some notes on installing for SSMS 20.