I would like to navigate to open a directory path from an in-line commented UNC path. SSMS integrates with Windows Explorer and Explorer allows UNC navigation from the address bar.

Indeed, when in the integrated browser, it is possible to navigate among UNC paths. HOWEVER, the click-thru functionality provided for http:/ prefaced URLs in the text editor of SSMS does not seem to exist for UNC paths. The Web Browser section of Options / Environment appears to open Internet Explorer options and the Text Editor / Plain Text / General section has the "Enable single-click URL navigation option", but does not appear to allow definition of what is detected as a URL.

Screenshots linked below




(added sample code below)

use [master]

-- http://www.google.com
-- \\servername\unc\BackupFolder\

select 'This query needs to be uploaded to the URL' Header
select 'and also saved for archiving at the UNC path'
select 'so is it possible to clickthrough to both?'

I would say you need to use file URIs:

For example:

SSMS Screengrab - Local

You can use UNC paths in a file uri if you convert the \ to / like this:

SSMS Screengrab - Share


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.