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 SSMS
Enabling Save Changes
Enable/disable intellisense
Connecting to msdn forums or submitting your feedback to connect
Filtering object names
Changing Top N rows values
Copy results with header
Hiding System databases
Inserting Code snippets for Objects
Open Query Window at Startup