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

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

  • Some of the simple things like this
    make work a lot easier. ๐Ÿ™‚

  • The Grateful DBA says:

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

  • […] 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" […]

  • Leave a Reply

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    Get Adobe Flash player