In order to use the Email and Pager option, you need to set up Database Mail.
And it leaves you free for more vital tasks such as sleeping and bingeing on whatever new Netflix series is out. To remove ApexSQL Genearte from SSMS 2016, go to the location where ApexSQL Genearte is installed, by default the ApexSQL Genearte tool is placed in Program Files under the ApexSQL folder, find and open the .pkgdef with a text editor such as Notepad++ with elevated privileges (Run as Administrator) file.As a DBA, automating your various jobs on SQL Server – taking backups, truncating logs, updating statistics, etc – is a good idea because it makes sure you don’t have to depend on your feeble memory for these important tasks. The second solution is preferred over the first, because if, for some reason, you would want to integrate ApexSQL Doc again to SSMS 2016, all that you would need to do is to remove the comments from the .pkgdef file and ApexSQL Doc will again appear in SSMS 2016. Now, ApexSQL Doc will be removed from the ApexSQL menu under SSMS 2016 main menu.
Instead of deleting the ApexSQL Doc folder from this location: C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions\ApexSQL, inside of the ApexSQL Doc folder, find and open the .pkgdef with a text editor such as Notepad++ with elevated privileges (Run as Administrator):Ĭomment all code from this file, save and close it: To remove ApexSQL Doc from SSMS 2016 go to this location: C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions\ApexSQL and delete the ApexSQL Doc folder:Ĭhange settings in the .pkgdef file There are two ways to remove ApexSQL Doc from SSMS 2016 as well.
The process of removing the ApexSQL Doc tool from SSMS 2016 is a little different then in SSMS 2012/2014. The second solution is preferred than the first, because if, for some reason, you would want to integrate ApexSQL Doc again to SSMS 2012 or SSMS 2014, all that you would need to do is to change the value in the above line from 0 to 1 and ApexSQL Doc will again appear in the SSMS 2012 and SSMS 2014. Open file with the Notepad++ or any other text editor as administrator, find the following line:Īnd in this line change the value 1 to 0 and save the change: The process of removing ApexSQL Doc from SSMS 2012 or SSMS 2014 using this way is finished.Ĭhange settings under the file
Under the ApexSQL Doc folder, find the file and delete it: Go to the location where ApexSQL Doc is installed, by default the ApexSQL Doc tool is placed in Program Files under the ApexSQL folder: To see the extensionof the file, go to Control Panel and under Folder Options in the View tab, uncheck the “ Hide extensions for known file types” check box, like on the image below:ĭeleting file The first way is by deleting the file and the second way, which is preferred, is to change the settings in the file. There are two ways of removing ApexSQL Doc from SSMS. Before starting the removing process, all running instances of SQL Server Management must be closedįor the purpose of this article, ApexSQL Doc will be used as an example, but the removal process is the same for all other ApexSQL tools that integrate into SSMS.