How to display Line numbers in SQL Server Management Studio(SSMS)

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.


Display Line numbers in SQL Server Management Studio

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.

Download latest version of SQL Server Management Studio (SSMS)

18 views0 comments