According to the Default settings, you are allowed to edit top 200 rows of any table in SQL Server 2008. But what, if you have more than 200 transactions in Database and need to edit/delete any current transaction that will take place in the last of list and is not included in top 200 rows.
Here we are going to tell you that how to increase the number of editable rows in SQL Server 2008.
Go to Start Menu and Click on “SQL Server Management Studio”
Select “Server Name”, Put Login and Password and Click on “Connect”
In database table, When you Right-Click, You can see “Edit Top 200 Rows”
Go to “Tools”, and Click on “Options”
In options window, Select “SQL Server Object Explorer” in left menu. You can see “Value for Edit Top Rows command” is 200
Click and Change it to 300 or 400 and Click “OK”.
Now go to any of database table, right-click and see the result.