Finding Objects in SQL Server During Development

I kept writing the same SQL over and over while developing to find the names of stored procs or to see what objects I had recently added.  So I created a quick stored proc that I now have in my tool box.

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

So if I just do:
obj ‘get%’, ‘P’

I’ll get

and if I call obj with no parameters I will get a list of all my objects with the most recently modified objects first. This works with SQL 2005 and above.