I made a slight change in mine to take into account an Offline DB:

insert into @dbs

select name from sys.databases where state_desc 'offline' order by name

Ken