Change Edit Top 200 Rows value in SSMS

One seemingly minor change to SQL Server Management Studio (SSMS) in SQL Server
2008 is that by default it will only allow the visually edit the top 200 rows .
This is primary to save on memory which can be drained by loading numerous rows
into the SSMS visual editor.

If, however, you don’t want to use SQL to edit or view rows and prefer just to
right click the table and view or edit a large number of  rows you can
change the default setting of Edit Top 200 Rows.

To do this, in SSMS navigate to Tools > Options… > SQL Server Object
Explorer > Commands
and then edit the value for Value for Edit
Top <n> Rows command
:

 




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |