How to combine and export query results from every database

"How many orders does each tenant have?" is a one-line query and a forty-database chore. Run it once and read the answer as one table.

Run the query

SELECT COUNT(*) AS Orders, MAX(OrderDate) AS LastOrder
FROM dbo.OrderHeader;

Select the group and press F5.

Read it as one grid

Results are grouped by script, with a row per database. Choose All Servers for the combined view: one grid across every target that ran the script, with a source column naming the database each row came from.

If a few databases returned a different shape, they are excluded and counted, so the grid never quietly mixes two things:

2 target(s) returned a different shape and were excluded.

Export

Export works on what is in the pane, so it is not limited to the history sample. See results export.