How to view line numbers in SQL 2005 management studio.
YES it is possible and very simple to switch on.
From the main menu bar go to;
Tools –> Options;
Select/Expand the Text Editor tree;
Select the All Languages tree;
Under the Display header, check the Line Numbers box.
Click the OK button and line numbers will immediately be shown on the left of the T-SQL window.