SQL Server 2008: Edit more than the first 200 Rows

Joined
Dec 14, 2009
Messages
413
Reaction score
104
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:



Hope it helps you.
 

Attachments

You must be registered for see attachments list