KPE - JHU - SSMS throws OutOfMemory exception on large result set
Running a query with a large result set from SSMS results in an System.OutOfMemoryException in SSMS
Upvotes: 3<=-=Jun 27 2008 11:05AM=-=>
Can you please provide us more detail on the issue? Was it running on Result to Text mode or Result to Grid mode?
The described behavior happens when you are doing Results to Grid.
I just tried the same query with Results to Text and found different behavior
Query returns some number of rows (can’t tell how many because the “rows” indicator at the bottom of the results pane remains at 0
and then returns with an error that says “could not replace text”
Results to file produces: (104831923 row(s) affected) and no errors<=-=May 28 2011 12:20AM=-=>
This is regarding the connect item 353243 you previously filed. Given that there is a workaround for the issue (save to file) and comparing other higher priority issues, we are triaging not to fix this issue. Please feel free to revert back if the workaround wont do (kindly add details).