When I execute sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
I get this error: The query has exceeded the maximum number of result sets that can be
displayed in the results grid. Only the first 100 result sets are
displayed in the grid.
When I looked at TOOLS\OPTIONS\QUERY RESULTS\RESULTS TO GRID, my non-XML data size is 65,535 (there is no XML stored in the output)
How can I increase the the number or Results displayed? There are only 137 tables in the database I am looking at; can I specify this number somewhere? Please advise
Thanks!
dkg