Hi,
For performing an easy auditing in SQL Server 2005 of the SQL Server and Database objects, I can recommend you to go in for a utility tool which has the ability to perform such tasks in fraction of seconds. The tool does gives a report on the who, what, when and where of the changes done like CREATE, ALTER and DROP on the database objects namely tables, stored procedures,trigers and much more. To know more features of the tool refer to
http://www.sqlserveraudit.org/