MS SQL – Change number of rows to edit


You need to edit many rows (>200) with in the Microsoft SQL Server Management Studio but you are limited to 200


In the SSMS click on Tools => options

Navigate to SQL Server Object Explorer

In the right side window select Value for Edit Top Rows command, change to 0 for all rows or set a specific number


Tested Platforms

Microsoft Windows 8 Professional
Microsoft Windows Server 2008 R2
Microsoft Windows Server 2012 R2
Microsoft SQL Server 2012

Hits: 187

Leave a Reply