SSMS – Change how many rows are returned by SELECT Top 1000 Rows

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.

1. Tools
2. SQL Server Object Explorer
3. 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.