Copy/Paste From SSMS to Excel

November 29th, 2010
by The Grateful DBA

From the “did you know” category…

Did you know you could highlight an object in SSMS, right-click it, and drag it to Excel? I oft have the need to list procedures in Excel and the “old” copy/paste methodology becomes cumbersome when you have to do it over and over again. But as I said; if you right-click and drag an object across your desktop to Excel, you can then un-click and have the option to move or copy it at your destination. This is very handy, particularly in a dual monitor setup where Excel’s open on one side and SSMS on the other.

By the way, before you ask, yes it works just as well with your destination being any of Microsoft’s Office Suite. I tested it in Word & Outlook just now and it works dandy. Not sure why I’m so surprised these Office applications work well together like that; I guess I shouldn’t be.

Have a Grateful day…Troy

Bookmark this on Delicious
Bookmark this on Digg
Share on Facebook
Bookmark this on Google Bookmarks
Share on LinkedIn
Bookmark this on Yahoo Bookmark

Tags: , , , , , ,
Posted in Office, SSMS | Comments (3)

3 Responses to “Copy/Paste From SSMS to Excel”

  1. Amit Banerjee Says:

    Some of the simple things like this
    make work a lot easier. :)

  2. The Grateful DBA Says:

    Thanks for stopping by the site Amit. Have a great day!

  3. Tweets that mention The Grateful DBA ยป Copy/Paste From SSMS to Excel -- Topsy.com Says:

    [...] This post was mentioned on Twitter by Jorge Segarra, Jacksonville SSUG and Troy Gallant, Troy Gallant. Troy Gallant said: [New Blog Post] From the did-you-know category: "Copy/Paste From SSMS to Excel" http://troygallant.com/?p=824 [...]

Leave a Reply

Get Adobe Flash playerPlugin by wpburn.com wordpress themes