Below is a script I use to quickly zip through every database, looking for objects that have been created or modified in the past 24 hours. In addition to running this following a deployment, it's also one of the first scripts I turn to as a first responder to a performance or troubleshooting incident.
if object_id('tempdb..#changed') is not null drop table #changed;
create table #changed
primary key ( databasename, schema_name, object_name, type_desc ),
databasename varchar(180) not null
, schema_name varchar(180) not null
, parent_name varchar(180) null
, object_name varchar(180) not null
, type_desc varchar(180) not null
, create_date datetime null
, modify_date datetime null
, diff int null
insert into #changed
db_name() as databasename,
schema_name(schema_id) as schema_name
, object_name(parent_object_id) parent_name
, name as object_name
,datediff( hour, modify_date, getdate() )diff
where substring(name,1,1) != ''#''
and substring(isnull(object_name(parent_object_id),''''),1,1) != ''#''
and datediff( hour, modify_date, getdate() ) <= 24;
select * from #changed order by diff;
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho