Live Chat Software by Kayako |
How to Edit More than 200 Rows in SQL Server 2008 Management Studio
Posted by on 13 February 2013 07:13 PM
|
|
If you want to change the default settings to allow you to edit more than the 200 rows at a time, or select more than 1000 rows, which are the default settings for Microsoft SQL Server. To modify “Edit Top 200 Rows” or “Select Top 1000 Rows” settings do the following:
In SQL Server 2008 Management Studio, go to “Tools” -> “Options” -> “SQL Server Object Explorer” -> “Commands“. | |
|