Please allow the results returned by any query or stored procedure to be saved to a new or existing table, either after the results have been generated or as a destination coded within the query. For multi-server queries from a central mangement server, please allow the destination table to be on the central mangement server.
I cannot begin to count the hours I have spent (wasted) trying to get the output of various ad-hoc queries and sp_help procedures into a persisted format. I find it hard to accept that I have to spend ANY time doing this - the SSMS tool has access to all of the meta information it would need to give me an option to save results to a new or existing table.
SELECT ... INTO can be used with a new or existing table, but only with single-server queries.
EXEC can be inserted to an existing table but only if the SP only returns one recordset.