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.
No comments:
Post a Comment