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 😀
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 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *