SSMS’s Clipboard Manager

12

August 19, 2015 by Kenneth Fisher

The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask what exactly they meant, but once it was described to me I realized it was something I’d wanted off and on for years. Basically it’s a tool that stores multiple copies in an extended clipboard. So you can copy several pieces of text over time and then paste the one you want. Justin Dearing (b/t) and Richie mentioned a Clipboard Manager called Ditto Clipboard Manager. Kendal Van Dyke (b/t) however mentioned one built into SSMS! Now, it only covers what’s currently in the clipboard and what’s been copied in SSMS but since I spend most of my time in SSMS (I even frequently use it as a text editor) that’s just fine. Once you’ve copied several pieces of text you can use Ctrl-Shft-V to cycle through the list in reverse order (last in first out). Want to see how it works? Take a look.

clipboardring

12 thoughts on “SSMS’s Clipboard Manager

  1. andreaallred says:

    I freaked out when this worked. All my co-workers came running over and I showed them. They thought I was in trouble or something. 🙂

  2. sqlpathy says:

    Amazing!!! Cool feature. Thanks Kenneth for sharing.

  3. Neil says:

    That’s brilliant!!!

  4. Brandon says:

    It’s not working for me – any particular setting change you need to do? I’m in 2008R2

    I’m holding CTRL+C to copy a couple of lines, then holding CTRL+SHIFT+V.

  5. Jodie White says:

    Sweet! Thanks for passing that along!

  6. Mladen says:

    I still prefer clipx (or whole-system alternative) in which you can also get a full menu of clipped items – so you can first choose before pasting.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,653 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: