Edit Top 200 Rows

  • October 4, 2010
  • 1 Comment

When you select/edit records in Microsoft SQL Server Management Studio (right click on a table), by default you can only edit the top 200 / select the top 1000 rows. You can easily change this parameter by going to Tools -> Options -> SQL Server Object Explorer and modifying the value of the appropriate property in the grid. The value ‘0’ equals all rows.

  1. Luegisdorf left a comment on October 5, 2010 at 11:39 am

    I ever wondered about the ‘200’, good to know where to change … Thank you.

Comments are closed.