Line Numbers in SQL Server

Created by
Wednesday, June 29, 2016

Line numbers in SQL Sever are essential when scripting large queries. Enabling them is fairly straight forward.

1) Open up SSMS and nanigate to the "Tools" section. Select "Options" from this section.

 

2) Within your options window navigate to "All Languages" and select "General". You will see an option for "Line Numbers". Select this option and hit OK. 

 

And thats it. Line numbers should now be available for your queries.

 

 

0
Rating
1 2 3 4 5

Save

Saved

Report

Reported
Reasons
Cancel
0 comments