In this article we have a look at how to enable line numbers in the SQL Server Query Window. You often see SQL Server code with or without line numbers. When you try to add line numbers with SQL code, you might receive an error massage. This behavior is by default and happens when we try to add line numbers manually.
Let us see how to enable or disable the display of line numbers in the SQL Server Query Window. The following defines some simple steps to do that.
Step 1: On the Tools menu, click "Options".
![Tool-Menu-in-SQL-Server.jpg]()
Step 2: When we click on the option, the Options window will be displayed:
![Tool-Menu-with-option-in-SQL-Server.jpg]()
Step 3: In the Options pop-up box select "Text Editor" and expand it and select "Transact-SQL" and expand it and select "General".
Or
"Text Editor" -> "Transact-SQL" -> "General"
![Tool-Menu-with-Transact-SQL-option-in-SQL-Server.jpg]()
Step 4: In the General page's right side panel you need to select the check box "Line numbers" under the "Display" section as shown in the following image.
![Line-number-in-SQL-Server.jpg]()
Step 5: Now click "OK" to save the changes and test it.
![Line-number-test-in-SQL-Server.jpg]()
Step 6: Uncheck the check box of the line number that prevents line number.