THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Copy as path instead of a send to program

What do you do to capture the fully qualified name of a file from Windows Explorer? If you are using a newer version of Windows than XP, you can easily get the fully qualified file name without installing or reconfiguring anything. All you need to do as add the Shift key to the mix after selecting the file of interest.

image

Figure 1. Normal right-click menu option.

image

Figure 2. Shift plus right-click menu option. Notice the addition of Pin to Start Menu and Copy as path.

Here is what Copy as path put in my paste buffer:

"C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf"

Considering that this particular path has embedded spaces, the double quotes surrounding the fully qualified file name are good to have. When there aren’t any spaces in the path or file name, the double quotes may be annoying. But the annoyance of double quotes is nothing compared to not having this functionality at all. Even on my own machine at home, I prefer Copy as path over other methods because I don’t want to install a send to clipboard program on my machine. The fewer programs that are installed, the better things are.

Published Tuesday, February 12, 2013 6:59 PM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

jerryhung said:

Nice tip, learned something new :)

February 12, 2013 8:31 PM
 

Nick B said:

Nice tip. I'll find that useful. Much better than typing in the address bar waiting for it to auto-complete the full file name.

Instructions for removing your greyed-out 'SkyDrive Pro' context menu

http://techdows.com/2012/07/remove-skydrive-pro-right-click-menu.html

February 13, 2013 6:04 PM
 

genkeep said:

Thanks you for sharing this cool tips , I also use Long Path Tool to copy or delete path files

genkeep

October 21, 2013 8:13 AM

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is both a Registered Nurse and a Microsoft SQL Server MVP experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. Experienced in systems integration and workflow analysis, John is passionate about combining his IT experience with his nursing background to solve difficult problems in healthcare. He sees opportunities in using business intelligence and Big Data to satisfy healthcare meaningful use requirements and improve patient outcomes. John graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement