• You can get this information from the Schema Changes report that is part of the default trace on sql 2005.

    Right click on the db in SSMS --> Reports.

    Or else you can create DDL triggers on the CREATE events and use these to record the information needed in a table.