Open source a Stash Management Studio plug-in, Projkyaddin, for all users using SQL Server Park Friends

Source: Internet
Author: User
Tags management studio

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.