How To Add Line Numbers In SQL Server Management Studio (SSMS)

If we have enabled line number in SQL Server management studio for query text, It will very useful to find quickly where is the error for a long SQL script. Here are the steps to enable Line Numbers In SQL Server Management Studio ( SSMS).

Open SQL Server Management Studio and Go to Tools > Options

In the Options dialog box navigate the Text Editor, Expand the Text Editor > Transact-SQL > General.

In the preview, panel Check “Line Number” and then click on OK. Now, when you will open a new query window than Line Numbers will be displayed.

Leave a Reply

Your email address will not be published. Required fields are marked *