Display row numbers in SSMS

How do you show row numbers in SQL Server Managment Studio? Read on and find out.

Here is a scenario you may run into. One of your developers may ask you to look at a huge, stored procedure and say, “there is a problem on line 493, can you help?”

I do not know about you, but that l cannot find that row number by eyeballing it.

To display row numbers, go to Tools -> Options in SSMS.

Now on the left side go to Text Editor -> All Languages -> General. In the middle of the screen check “Line Numbers” and press OK.

Now press OK, and line numbers will now show up in your editor.