How to change the context menu SELECT and EDIT TOP max rows limit in SQL Management Studio

Posted on by

By default when using right clicking a table and selecting or edit rows, SQL Management Studio will select only the TOP 1000 rows or edit the TOP 200 rows of any table.

SQL Management Studio Select edit limit top context menu increase limit top

To increase the SELECT or EDIT context menu limit:

  1. Click tools from the dropdown menu
  2. Choose options
  3. Expand the server object explorer
  4. Choose commands
    SQL Management Studio select edit limit top context menu increase limit top
  5. Change the values in Table and View Options section to the required amount and click OK