how to increase the edit row number RRS feed

  • Question

  • hi all,

    how to change the number inside of 'edit top 200'?.



    Thursday, October 10, 2019 7:14 PM

All replies

  • I have a link for how to do it a few years ago:


    There some setting changes between SQL Server 2005 and 2008. One of them is by default you can edit only 200 records. You can modify settings to allow you to SELECT or Edit all records following the below steps. 

    Modify  “Edit Top 200 Rows”:

    Tools->Options->SQL Server Object Explorer>Commands

     If you would like to edit more than 200 rows, you can choose the “Value for Edit Top <n> Rows command” setting from menu.

     If you would like to select more than 1000 rows, you can choose the “Value for Select Top <n> Rows command” setting from menu.

    If you want to SELECT or EDIT for all rows as before, you can simply change the number <n> to 0."


    Thursday, October 10, 2019 7:17 PM
  • From Menu bar -- > Tools --> Options and then at below:


    Thursday, October 10, 2019 7:18 PM