Show line numbers in transact sql in Sql server management studio (SSMS)

Sql server management studio supports many types of editors like transact sql query editor, XML Editor, Text Editor Etc. Sometimes we need to display line number in different editors. Here we will set to show line numbers in different editor in sql server management studio 2014, 2012, 2008 and 2005.

Step 1: Go to Tools -> Options as shown in following diagram:

SSMS Setting Options

Step 2:

To Show line numbers in all languages text editor

Got to: Text Editor -> All Languages - > General

SSMS All Languages Show Line Number

Checked Line Numbers check box and click on OK button.

To Show line numbers in only in transact sql editor

Go to: Text Editor -> Transact-Sql - > General

SSMS Transact Sql Editor Show Line Number

Checked Line Numbers check box and click on OK button.

To Show line numbers in only in XML editor

Go to: Text Editor -> XML - > General

 

SSMS XML Editor Show Line Number

Checked Line Numbers check box and click on OK button.

To Show line numbers in only in plain text editor

Go to: Text Editor -> Plain Text - > General

SSMS Plain Text Show Line Number

Checked Line Numbers check box and click on OK button.