Increase Maximum rows returned beyond 10000
Please make the number of rows returned user configurable beyond the current limit of 10,000. As a sql management console replacement tool, this is a firm requirement for me.
Done. Click the new ‘Results in Grid’ icon. The result count is then limited only by memory.
-
Anonymous commented
this is not working for text output. it does not render to a data grid even though i have that option selected.
-
Swapnil Narlawar commented
I am new to linqpad. Even after clicking the Results in Grid icon the result count is not more than 10000. I even tried editing the RoamingUserOptions.xml file but the changes revert back to default. Could you help?
-
gksmithlcw commented
I definitely require this feature in terms of SSMS and its replacement. I have to run large queries that may return hundreds of thousands of rows.
-
foofoodog commented
Ya, no. It makes no sense to render 10,000+ records like that, in a verbose html format. If you are thinking SSMS replacement then you are thinking results to text or results to file, or better yet, results to XML.
-
You can set the limit to anything you by editing the following XML file:
%appdata%\linqpad\RoamingUserOptions.xml<MaxQueryRows>1000</MaxQueryRows>
Be careful, though. Because LINQPad uses a web browser to render the results (to allow for nested tables and so on), it could get very slow and unresponsive if you set the limit too high.
-
Ron H. commented
Me too.