In Management studio, when you open query editor, there is a thin yellow vertical line in the left margin for each line you type. Sometimes the line disappears and sometimes it is green in color. Did you ever notice that? If not, continue reading……
These colors represent the modifications done to the file.
Yellow –modification, not saved
Green – modification, saved
No Color – no modification
Now, can you change these colors? Ofcourse, goto Tools->Options->Environment ->Fonts and Colors. You can change the colors for various display items.