Display line numbers in SQL Server Management Studio

I just watched a great movie about databases. Now I can’t wait for the SQL.

If you’re working with SQL data, SSMS is the GUI of choice. And if you’re writing T-SQL, you’re going to encounter errors that need debugging.

This quick post is about how to show line numbers in the editor.

By default, line numbers in SSMS aren’t shown but there is a setting that can change that so you aren’t debugging in the dark.

Getting line numbers in SQL Server Management Studio is simple. Go to Tools > Options > Text Editor > expand Transact-SQL. Next, select General and check the Line numbers option.

You’re welcome. Until next time…

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *