Showing posts with label SQL 2008. Show all posts
Showing posts with label SQL 2008. Show all posts

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 :)
Related Posts with Thumbnails