How to check who has done what in sql server 2005?

In my production DB, everyday I find some values have been changed. Is there any way to check who has done these changes? These changes must have been done by开发者_如何学编程 logging into the DB itself. I need to who has done it and when.

Are the values changed in tables? Or are they properties of the database? If they are in tables then you can implement trigger-based auditing on your tables as described in this article.

Then you need to set up auditing on your tables.