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 🙂