Tag Archives: Color Highlighting

Greens are good – SSMS script feedback

It’s the little things in life that please me, and there have been a few things of late I have noticed or directed to which have left that warm fuzzy feeling.
The latest is a nice little feature that appears to have been present for a very long time. Why I have not noticed (or paid attention) to it so far is beyond me.

After writing a script in SSMS if you wish to reuse it, then it is probably a very good idea to save it now. However, before you do, have a look to the side of the script and you will notice a yellowish colour by the side of it.

Now I shall save my script…

…Notice the colour that is now next to the script lines, it has turned a lovely shade of green. This appears to indicate that each line has been saved.

What I really like is when various lines are subsequently changed. Any line that is edited reverts back to the non-green colour giving you instant feedback as to all edits that have been made and a good indication whether you want to commit these script changes to disk or not.