SQL SERVER 2016 – Management Studio Highlighting Current Line Option

With every new release, there is changes that are being made to the tools that support it. It is tough sometimes to keep up with the pace. I am always an old school guy and I try not to change the style that involves changes to the way things function. When I installed SQL Server 2016 Management Studio, there was something fresh about the IDE, but I was trying to get to terms to why I was feeling little weird. Let us learn about Highlighting Current Line Option in SSMS 2016.

It took me a couple of days before I got my hands on a SQL Server 2014 machine to understand the apprehensions. It was nothing big, but was mostly cosmetic in nature. I knew for sure, anything that involves SQL Server Management Studio, it must be available as Options somewhere. But that is something for a different discussion.

So if you look at a typical script which I open inside Management Studio, it had a line highlighter which came up which was quite different.

SQL SERVER 2016 - Management Studio Highlighting Current Line Option Line-highligted-01

It is nothing special if you come from a Visual Studio background. People have been using this for years and now there is also a nice blue marker as shown in the figure above to where you are in the overall script location. The thing that was bothering me was the gray box when my cursor was in a given line. This is also shown above. I didn’t feel good about it and was wondering how I can remove the same whenever I open up SSMS.

So I went to the Options page to check what has been added:

SQL SERVER 2016 - Management Studio Highlighting Current Line Option Line-highligted-02

Under the “Text Editor” -> General section I found the options for “Display”. Here there was an option called as “Highlight current line”.

This is exactly what I was looking for. To get back my old style, I just went ahead and unchecked this and saved. This was a huge thing for me because I try not to change some of my programming style when working with tools. I sometimes love them the way they are because I am used to them.

Do you see this feature interesting for you? Will you use them by default? Or are you from, my school of learning wherein you want to remove this part alone. I am sure there are many who are like me – but I am open to change. Do let me know how you made this as a useful in your environments? Write me a note via the comments below about Highlighting Current Line Option in SSMS.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Server, SQL Server 2016, SQL Server Management Studio
Previous Post
Comparison – Logical Architecture between Oracle and SQL Server
Next Post
PowerShell – Querying SQL Server From Command Line

Related Posts

6 Comments. Leave new

  • nakulvachhrajani
    May 19, 2016 12:32 am

    When I am doing normal scripting, I prefer to use line numbers rather than line highlights.

    When merging/comparing files, line numbers may not make sense (because the files may have overlapping/moved content, etc). In that case, having a visual indicator for where you are actually makes much more sense and helps me avoid getting lost.

  • Is it possible to make it transparent? It’s hiding underscores but I’d like to keep it….

  • I’m using black background and white text. I just found the option to change the color of the line highlight. It’s under Tools>Options>Environment>Fonts and Colors>Display Items: Highlight Current Line (for window active and inactive).

    I’m using dark gray now, my white text is on top so underscores aren’t hidden anymore.

  • Thank you so much!!!! This was driving me crazy!!!! I found it very annoying. I know it is something simple, but it was new and different and I did not like it. But, I love that they make it available to turn on and off.

  • Thanks, just installed the new Management Studio today. I looked all over for a way to turn that off.


Leave a Reply