Every now and then I need to select or edit more than default number  of records in MS SQL Server Management Studio so instead of navigating  through it every time. Let’s change it to be able to view/edit more entries by default.

Solution

Go to Tools and select Options

Select SQL Server Object Explorer > Commands and increase the numbers as you desire

And now you can see it in action when you right click on a table.

Thats all. Have a great day! 👀