Hi,
For proper auditing of the activities of SQL Server and Database objects in SQL Server 2008 R2, I can recommend you to try in a utility tool which has the ability to do such tasks excellently. The tool gives the details of who, what, when and where for CREATE,ALTER and DROP operations performed on the SQL Server and Database objects. Generates the real time alerts and scheduled reports of these changes in CSV, HTML and PDF formats. It supports SQL Server 2008 R2 datacenter, enterprise, standard and workgroup editions; and to know more features of the refer to
http://www.lepide.com/sql-server-audit/