Live Chat Software by Kayako |
How to Edit More than 200 Rows in SQL Server 2008 Management Studio
Posted by on 24 October 2012 03:28 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“. | |
|