The step by step approach to add External tools to SSMS is given below. (Screenshots depict how Notepad has to be added as external tool to SSMS)<\/p>\n
Step1:<\/p>\n
Step2:<\/p>\n
![\"\"](\"\/wp-content\/uploads\/2011\/12\/SSMS-External-Tools.jpg\" "\\"SSMS")
<\/a>Now External Tools Dialog Box pops up. Using this Dialog Box External tools can be added to SSMS.<\/p>\n
Step3:<\/p>\n Update the Title with the title you want for this extenal tool(basically the name of the external tool). For adding Notepad as an external tool there is no mandate to add Arguments and Initial directory. Now click on apply, Then click on OK.<\/dd>\n You can find the added external tool in the Tools Menu item.<\/p>\n Now when the external tool is clicked in the tools menu, the tool opens up with the defined options in External tools Dialog.<\/p>\n How to add toolbar Button for External tool?<\/strong><\/p>\n External tools can be easyly accessed when a toolbar button is added to external tool. The cursor initlly has a x mark. As you drag the item the Cursor changes into a + mark indicating it can be added at that location. Leave the cursor at the location where external tool button is needed.<\/p>\n Using this method External tool can be added to the tool bar, or as a menu item.<\/p>\n","protected":false},"excerpt":{"rendered":" SQL Server Management Studio provides a functionality to add external tools(Windows Bases or .Net Based). This will be in great use when an external executable file has to be run from SSMS. How to add external tools to SQL Server Management Studio? The step by step approach to add External tools to SSMS is given…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[610],"tags":[611,612,613,614,615,616,617,618,619,620,621,622],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/101"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=101"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/101\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a>
\nThe below screenshot shows notepad being selected as command from location C:WindowsSystem32notepad.exe<\/b><\/p>\n<\/a>
\nIf the external tool has arguments then add them in the arguments section.
\nAlso add the intial directory if initial execution directory is needed by the external tool.<\/p>\n
\nThe tool Title is given as ExternalToolNotepad.<\/p>\n<\/a><\/p>\n<\/a>
\nThis can be acheived using Customize Option in the tools menu.<\/p>\n<\/a>
\nNow Customize dialog box pops up
\nSelect Tools under Catagories in the commands tab.
\nDrag the External Command1<\/strong> item in the Commands section to the location on SSMS where you want the button to be added.<\/p>\n<\/a><\/p>\n<\/a>