Basic Logics · Real Scenario Logic's

Show and Hide Line Numbers in SQL Server Management Studio (SSMS)

Introduction

Many of us would face some challenges as a developer while debugging the SQL Codes. SQL Server would show us some error message with the particular Line Number where the error has occurred. The main aim of this post is to see, how to Show/Hide Line Numbers in SSMS.

Show/Hide Line Numbers in SSMS

Before Enabling Pic-

Before Enabling, Line Numbers are not here!

STEP 1-

Click Tools–>Options as highlighted in green color below.

STEP 2-

In Options Dialog Box, Under Text Editor, in Transact-SQL, General –>Line Numbers .

Enable the checkbox, If you want to Display/Show Line Numbers in SSMS.

Disable the checkbox, If you want to Hide Line Numbers in SSMS.

After Enabling Pic-

After Enabling, Line Numbers are here!

Note-

If we Double-Click the Error message in the Message Area, SSMS brings us to the error line like below.

Conclusion

Thus, we saw how to Show and Hide Line Numbers in SSMS. This is Unit Tested in both Azure SQL DB and On-Premises.

Thanks for reading!

FOLLOW BLOG for interesting upcoming posts!

Advertisement

2 thoughts on “Show and Hide Line Numbers in SQL Server Management Studio (SSMS)

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Connecting to %s