SQL SERVER – SSMS – Enable Line Numbers in SQL Server Management Studio

During the Comprehensive Database Performance Health Check, I never take access to the server. We always connect via GoToMeeting or WebEx. Due to the security issue, I always prefer that I never log in to the server directly but I always like to teach and guide DBAs who are working with me on another side, how to do SQL Server Performance Tuning. However, while I do this, I face often challenge when I am looking at the screen and tell DBA on the other side to change any specific part of the query. This is when I believe the trick of enabling line numbers in SSMS comes in handy.

Let us see in this blog post how will we enable the line numbers in SQL Server Management Studio. Line numbers can be very handy when the meeting is happening on the internet and different individuals are meeting together.

First of all, go to Menubar >> Tools >> Click on Options

SQL SERVER - SSMS - Enable Line Numbers in SQL Server Management Studio linenumber2

Next, go to Text Editor >> Transact-SQL >> Settings

On this screen, select the checkbox which says Line Number

SQL SERVER - SSMS - Enable Line Numbers in SQL Server Management Studio linenumber3

Now go back to SQL Server Managment Studio, Query Editor and you will see rows numbers.

SQL SERVER - SSMS - Enable Line Numbers in SQL Server Management Studio linenumber1

I would be interested to know what is the current settings in your system for the line number.

Reference: Pinal Dave (https://blog.SQLAuthority.com)

SQL Server, SQL Server Management Studio, SSMS
Previous Post
SQL SERVER – Automated SQL Server Consolidation and Right Sizing – Save 50% Data Platform Costs
Next Post
SQL SERVER – Simple Method to Extract Scale Part From Decimal Number

Related Posts

3 Comments. Leave new

  • in all our database’s it was not set.

    Reply
  • I have my line numbers disabled – usually I’d just look at the “status” bar at the bottom of the window which shows Ln X Col X.
    But this was a good reminder about it, thanks!

    Reply

Leave a Reply