How To Enable Line Numbering


Line numbers can be very helpful when writing/debugging code in SQL Server Management Studio. Below are the simple steps to turn on line numbering in the query window.

Before and After

Step 1

From the menu at the top, select Tools –> Options

Select Tools --> Options

Step 2

From the list on the left, choose Text Editor and then All Languages.  Then select the Line numbers check box on the right.  Choose OK to save your settings.

Line Number Options