Alter SQL in “Edit Top 200 Rows” in SSMS

To change the “Edit top 200 Rows” in SSMS, Microsoft SQL Server Management Studio, there are two options, either use the sql edit or change the popup options.

Right click the results and select Pane -> SQL, this will show the sql that you can then edit and show only part of your database.

Second option is to permanently change the popup window and change the number of rows. Go to Tools -> Options -> SQL Server Object Explorer -> Edit the “Value for Edit Top <n> Rows command.

Now when you right click you have e.g. “Edit Top 400 Rows”.

Posted in Tips and Tricks, Windows Tagged with: , ,