Please rate this item: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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 *

CJayMead's SQL Server, Endeca, MS Office Help © 2018