As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to display line number in query window.
When you write queries in Query window, the line number is not displayed at default. If you want to display line numbers, you can set the following option.
In the Toolbar, goto Tools-->Options-->Transact-SQL-->General. At the bottom of the window, check the ckeck box labelled Line Numbers and click Ok. You can see your query window with line numbers now.
Other posts that come under Exploring SSMSEnabling Save ChangesEnable/disable intellisenseConnecting to msdn forums or submitting your feedback to connectFiltering object namesChanging Top N rows valuesCopy results with headerHiding System databasesInserting Code snippets for ObjectsOpen Query Window at Startup