When you right-click a table in SSMS, you can “Select Top 1000 Rows” and “Edit Top 200 Rows.”
You can change how many rows are returned by changing the defaults.
- Tools
- SQL Server Object Explorer
- Change the values under Table and View Options
Change these values to whatever makes sense in your situation.
Note: if you change it to 0, it will return all rows.