Retrieve Data select top n rows
Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).
I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).
Sebastián Golbert commented
I have the same problem. The pagination mode doesn't work as expected, I must edit the SQL query in order to preview big tables. This is done correctly in other inferior products like SSMS.