By default in SQL 2005 line numbers are not shown in the Query pane. You can however add them if you need them quite easily.
Follow the steps below to toggle the line numbers on or off as needed.
1. Select “Tools” from the menu bar and then select “Options”.
2. Then expand the “Text Editor” option.
3. Next expand the “All Languages” option.
4. Finally select the “General” option and in the lower Display leaf of the screen place a check in the box “Line Numbers”.
Now when you open a “New Query” line numbers will appear. Reverse the steps to remove the line numbers.
No Comments