question

sp_msforeachdb seems the answer, see [this link][1] [1]: http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

Getting it into separate tabs in Excel is going to be the most difficult part. Does it *have* to be Excel? It would be very easy to do it as a SQL Reporting Services report. You could use sp_msfoeachdb to iterate through the databases, use db_name() to include the database name in the resultset, and use a Table contained in a List that splits on database name to present them as separate tables. If you don't fancy that, have a look at what's involved in doing it with Integration Services (eg. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0fbefeb2-b22d-4774-b1b0-069c6f729160/capture-output-of-multiple-sql-queries-in-separate-tabs-of-an-excel-workbook?forum=sqlintegrationservices).