Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Nakul Vachhrajani is a Technical Specialist & Systems development professional with iGATE. He holds a MCTS (SQL Server 2008: Implementation & Maintenance)
Browse by Tags · View All
#SQLServer 305
SQL Server 304
Administration 252
DBA 241
T-SQL 234
#TSQL 232
Development 226
Tips 216
Guidance 148
Best Practices 119

Archive · View All
April 2011 14
March 2012 11
December 2011 11
March 2011 11
December 2012 10
October 2011 10
January 2011 10
September 2013 9
January 2013 9
November 2012 9

#0220-SQL Server-Enable single-click URL navigation

Dec 10 2012 12:00AM by Nakul Vachhrajani   

There are many productivity improving and usability tips and tricks related to the SQL Server Management Studio (SSMS). Ever since I started my blog (about 2 years ago), I have been writing mostly about these tips, and the list never ends! In today’s post, I will show how to configure the SSMS to recognize URLs within code comments.

One may place URLs in code comments for many reasons. Those that are applicable for me are:

  • Referencing a specification
  • Referencing a code defect/enhancement: The URL would point to the related TFS defect
  • A link to Sharepoint or any collaboration tool that development teams may be using
  • A link/citation to a website/blog that has been used as reference

For most languages & file extensions that the SSMS can handle, using Ctrl+click on any hyperlink opens the built-in web-browser and launches the associated page within SSMS. [One difference between SSMS for SQL 2012 and SQL 2008 is that the SSMS for SQL 2008 does not show the hyperlink in blue/underline].

Image showing single-click URL navigation, where using Ctrl+click over a hyperlink will launch the link in a browser.

The SSMS for SQL Server 2012 and below (tested for SQL Server 2008 and SQL 2008 R2), provide a text editor option – “Enable single-click URL navigation” that allows the user to control this behaviour. To access this option, go to Tools –> Options –> Text Editor –> All languages –> General (one can do this for specific languages too).

SSMS option to toggle single-click URL navigation (Tools->Options->Text Editor)

Un-checking this option will cause SSMS to stop recognizing hyperlinks within code comments:

Unchecking the "Enable single-click URL navigation" under Tools -> Options causes SSMS to stop recognizing hyperlinks.

The benefit of keeping “Enable single-click URL navigation” checked is that when developing and reviewing T-SQL code, it becomes very easy to reference and reach out to related documentation. I trust you found this feature useful.

Until we meet next time,

Be courteous. Drive responsibly.

Tags: #SQLServer, SQL Server, Tips, Tools and Utilities, SSMS, HowTo

Nakul Vachhrajani
4 · 36% · 11648


Your Comment

Sign Up or Login to post a comment.

"#0220-SQL Server-Enable single-click URL navigation" rated 5 out of 5 by 5 readers
#0220-SQL Server-Enable single-click URL navigation , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]