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.