T-SQL Running a script for each database using sp_msforeachdb

Here is a quick example of using SQL server stored procedure sp_msforeachdb

exec sp_msforeachdb '

use [?]
select count(*) from sys.all_objects

'