How to turn on line numbers – ALL APPS

Directions for the Following list of APPs: (Find App then Skip further below to see full Instructions)

Visual Studio –

Notepad –

SQL Management Studio  – Instructions Below

VBA –  You can’t

Eclipse –

 

Instructions Section

Visual Studio –

Notepad –

SQL Management Studio –

Step1: Go to Tools > Options

image

Step2: In the Options dialog box navigate to Text Editor > Transact-SQL > General

image

Step 3: Check “Line Numbers” and click on “OK”

image

Now, when a query window is opened Line Numbers will be displayed:

image

VBA –  You can’t

Eclipse –

 

Resources: https://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/20/sql-server-displaying-line-numbers-in-query-editor-ssms