Display Line Numbers in a SQL Server Management Studio Query Window (SSMS)

Introduction

Sometimes when we encounter an error message for a T-SQL query while debugging. The SQL Server shows the error message along with the line number where the error has occurred. In this article, I will give a simple tip to enable the Line Number feature in SSMS. This feature is applicable to all versions of SSMS starting from SQL Server 2005.

Note: By Default in SSMS display line number is DISABLED.

Display Line Numbers in SQL Server Management Studio (SSMS)

  • Open SSMS. Click Tools and navigate to Options (Tools -> Options).
Fig. Tools -> Options
  • In the Options dialog box on the left side pane expand the Text Editor and then expand Transact-SQL. 
Fig.2 Text Editor Option
  • In General options, under Display  section, Check the Check Box next to Line Numbers as shown in the above and click OK.
Fig.3 Line Numbers in SSMS Query Window

Conclusion

Thus we can display line numbers in SSMS Query Window. I assume this tip was very useful to you all. Please share your feedback in the comment section.

Consider to read other articles from me in SQL Server,

11 thoughts on “Display Line Numbers in a SQL Server Management Studio Query Window (SSMS)”

Add yours

  1. Pingback: 5 Tips to Improve SQL Query Performance – Learn With Sundar
  2. Pingback: Change Schema Name Of Table In MS SQL Server – Learn With Sundar
  3. Pingback: Difference between CURRENT_TIMESTAMP vs GETDATE() vs SYSDATETIME() vs GETUTCDATE() in SQL Server – Learn With Sundar
  4. Pingback: Multiple Backup Files of the SQL Server database with SSMS and T-SQL – Learn With Sundar
  5. Pingback: Recover unsaved SQL queries in SSMS – Learn With Sundar
  6. Pingback: Set custom colors to differentiate between environments in SSMS – Learn With Sundar
  7. Pingback: Cycle Clipboard Ring In SSMS – Reuse Copied Items – Learn With Sundar
  8. Pingback: Customize Azure Data Studio with Dashboard Widgets – Learn With Sundar
  9. Pingback: Create and Publish SQL Server Database Project With Visual Studio – Learn With Sundar
  10. Pingback: Link a SQL Server Database Project to a Git Repository – Learn With Sundar
  11. Pingback: Schema Comparisons using Visual Studio SQL Data Tools – Learn With Sundar

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

Website Built with WordPress.com.

Up ↑

%d bloggers like this: