How to enable Edit All Rows feature in SQLServer Management Studio?

By default SQL Server Management Studio provides an option to Select Top 1000 Rows and another option to Edit Top 200 Rows option when you right click on a table in the Object Explorer.

If you have few rows like less than 1000 and if you want to edit row # 500 without using Update query, SQL Server Management Studio provides an option to Edit All Rows.

For that,

• Go to Tools menu
• Go to Options

In the Options dialog, Go to SQL Server Object Explorer -> Commands

This gives you the following window, where you can see 200 for Value for Edit Top <n> Rows command option and 1000 for Value for Select Top <n> Rows command option.

Change these numbers to 0 to if you want to edit all records like shown below.

Now you can see Edit All Rows option when you right click on the table in the Object Explorer.

CAUTION : Do not do this, if you have huge number of rows.