use master
go
create database d1
go
use d1
go
create procedure dbo.p1 as select db_name(), getdate();
go
create database d2
go
use d2
go
create procedure dbo.p1 as select db_name(), getdate();
go
create database d3
go
use d3
go
create procedure dbo.p1 as select db_name(), getdate();
go
use master
go
alter database d2 set auto_close on
go
use master
go
select  d.Name
      , d.is_auto_close_on
      , d.state_desc
      , sp.spid
    from sys.databases d
         left join sys.sysprocesses sp on sp.dbid = d.database_id
    where d.name like N'd_'
;
declare @cmd nvarchar(4000);
declare cur cursor for
select d.name+N'.dbo.p1' from sys.databases d where d.name like N'd_'

open cur
while 1 = 1
begin
    fetch next from cur into @cmd
    if @@fetch_status <> 0
        break;
    exec @cmd
end;
close cur
deallocate cur
;

exec sp_readerrorlog 0, 1, N'Starting up'