The Projkyaddin is a management Studio plug-in that installs packages of more than 500 KB and is compatible with SSMs 2005, SSMs 2008, SSMs R2, ssms 2012, SSMs 2014, the function is to provide a shortcut to the script file on the hard disk in the Management Studio toolbar, directly click the shortcut button to add the script content in the current query window (if not, create a new query window). Open source, you can customize the contents of the script to load the part. Similar to the Favorites bar feature of IE browser.
With this plugin, you can directly execute a common script directly in the Management Studio interface, without worrying about where to look for the script.
Use Method 1:
After the plugin is installed, the "Projkyaddin" directory is automatically created in the current user's "MyDocuments" directory and placed into three sample scripts, and a shortcut to these scripts is added to the toolbar after Management studio launches. The directory is the default script loading directory. Only top-level directory script loading is supported, and the loading of the next-face directory script is not supported.
Use Method 2:
In addition to the default script loading directory, you can also configure any other loading directory.
In the plugin installation directory there is a file "Scriptfolders.txt", you can add a custom script directory, a single directory line. For example, some scripts are located under "D:\SqlServer\Scripts\IO", so just add a line "D:\SqlServer\Scripts\IO" (no double quotes) to "Scriptfolders.txt" to OK. Other customized catalogs are placed in a separate toolbar.
Use Method 3:
In the Management Studio main Menu bar, under the Tools menu, the menu "Reload Projkyaddin" can reload all the script shortcuts from the configuration file, eliminating the hassle of restarting management Studio.
Use Method 4:
The toolbar where the script shortcut is located can change position, you can drag or modify the custom docking position, change the default upward docking. For example, you can drag the toolbar to the left of the Managementstudio, or to the right.
Note 1: In Management Studio 2005, in order to load plug-ins Normally, you may need to install business Intelligent Development Studio, which will work without any SP patch packs. Other Management Studio versions do not have this limitation.
NOTE 2: If you move the mouse to the script shortcut, the prompt box that appears can display up to 255 characters of the content.
Installation package: Http://files.cnblogs.com/ProJKY/ProjkyAddin.msi.zip
Source: Http://files.cnblogs.com/ProJKY/ProjkyAddin.src.zip
Source Source Address: Http://projkyaddin.codeplex.com may have a bug, the repaired code will be submitted to CodePlex.
Follow-up will write a little Managementstudio plug-in programming method, the original Daoteng SSMS plug-in programming, or very laborious, thank you for your support.
Finally, want to say a sentence, oneself keep, better give everybody, hope everybody can like this plugin.