SQL: Edit Top 200 Rows, and Select Top 1000 Rows- change to UNLIMITED!!

Hi All

I have just found the option to remove the edit/select “top” default in SQL Server Object Explorer.

Go to Tools, Options. Expand SQL Server Object Explorer, and select Commands.

Set the two values shown below to zero:

  • Value for Edit Top Rows command
  • Value for Select Top Rows command

SQL Server Object Explorer Options

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.