Finding Objects in SQL Server During Development

create proc obj(@name varchar(50)=null, @type char(1)=null)
as
begin
set nocount on

select o.name, 
o.type, 
convert(varchar(10),o.create_date,1) created, 
convert(varchar(10),o.modify_date,1) modified
from sys.objects o
where (@name is null or o.name like @name)
and (@type is null or o.type = @type)
and o.is_ms_shipped = 0
order by o.modify_date desc

end
go