Thursday, June 5, 2014

Change ‘Edit Top 200 Rows" on SQL 2008

Working with live data and 'concerned' clients, i always have to recheck and modify data from database using SQL 2008. 

The default value for editing table only 200 rows, and the rest i have to do it using script. A bit tedious because i cannot actually read the data and edit it. 

But here is the solution yey :D

Tools >Options >SQL Server Object Explorer, Expand this tree ‘Commands’

I change the '200' to 0 , and i will get all data :)
Hope this will help :)

No comments:

Related Posts with Thumbnails