How to Edit More than 200 Rows in SQL Server 2008 Management Studio

There are two options to edit more than 200 rows in SQL Management Studio

Option 1-changing the setting of 200 rows permanently:

Tools-->options-->SQL Server object explorer -->Commands
Edit "Change Value for Edit Top <n> Rows Command"

Option 2-changing the setting of 200 rows temporarily:

Right click Table-->click on Edit Top 200 Rows -->New Query window will be opened.

You can change the SELECT TOP (n) statement.

After changing it, click on the red exclamation mark (!) to update the selection.


Total votes: 372


Be the first one to write about this.

Your Comment

The content of this field is kept private and will not be shown publicly.
  • Lines and paragraphs break automatically.