Thursday, January 3, 2013

How to edit more than the default 'Edit first 200 rows' in SQL server

The default option in SQL Server for editing the table through the SSMS UI is 200 rows. Luckily that's a setting you can change!

1. In SSMS > click Tools > Options
2. Expand SQL Server Object Explorer > Commands
3. Modify the number to anything you want and save. 0 = all rows

No comments:

Post a Comment