Updated: Dec 31, 2021
While working with a long SQL script, the line numbers help you quickly navigate to a particular line to look at or correct the script.
How can we enable or disable line numbers in the Query Editor of SQL Server Management Studio(SSMS)?
Launch Microsoft SQ Server Management Studio and navigate to Tools -> Options -> Text Editor -> Transact-SQL -> General and put a check on Line numbers to display line numbers in the query editor.
Similarly, uncheck the box before line numbers to stop displaying the line numbers.
Note: You need to restart SSMS after enabling or disabling line numbers in SSMS.
Note: To download latest version of SQL Server Management Studio, refer to Microsoft docs.