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-
Click Tools–>Options as highlighted in green color below.
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-
If we Double-Click the Error message in the Message Area, SSMS brings us to the error line like below.
Thus, we saw how to Show and Hide Line Numbers in SSMS. This is Unit Tested in both Azure SQL DB and On-Premises.