I tend to use the following:

USE [DBName]

SELECT name AS ObjectName

, modify_date AS ModifiedDate

, type AS ObjectType

, type_desc AS TypeDescription

FROM sys.all_objects

More info on sys.all_objects is at: http://msdn.microsoft.com/en-us/library/ms178618.aspx

There are also system catalog...

Trying to use the report as more of a work list. Having a user click a link (button etc) would fire a call to the SP that would make the...