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

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. To increase the SELECT or EDIT context menu limit: Click tools from the dropdown menu Choose options Expand the server object explorer Choose

Read More