MS SQL – Change number of rows to edit

Problem

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

Solution

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

myite-sql-01

Tested Platforms

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

Hits: 2

Leave a Reply