SQL Server 2008: Edit more than the first 200 Rows

[schneemann101]

SQL Server 2008: Edit Top 200 Rows



To change this setting, follow these steps from SQL Server Management Studio (SSMS):

Tools > Options (This opens the General Scripting Options Dialog Box)
SQL Server Object Explorer > Commands
Table and View Options: Value for Edit Top Rows command (Change this value)​

After modifying the setting, you will see that the menu is updated accordingly.




Credits goes to:

You must be registered to see links

You must be registered to see links

Hope it helps you.

 

[Xc0deRed93]

You could just set it to 0 and you'll get all the tables. like the mssql 2005.