patternsqlMinor
Configure SSMS intellisense / web browser settings to accept UNC directory path inputs
Viewed 0 times
directorysettingsssmspathinputsacceptbrowserintellisenseuncweb
Problem
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
Screenshots linked below
(added sample code below)
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]
go
-- http://www.google.com
-- \\servername\unc\BackupFolder\
select 'This query needs to be uploaded to the URL' Header
union
select 'and also saved for archiving at the UNC path'
union
select 'so is it possible to clickthrough to both?'Solution
I would say you need to use file URIs:
For example:
You can use UNC paths in a file uri if you convert the
For example:
You can use UNC paths in a file uri if you convert the
\ to / like this:Context
StackExchange Database Administrators Q#111203, answer score: 3
Revisions (0)
No revisions yet.