Any type of Audit mechaninsm in SQL Server?

Does anyone know if there is any type of audit trail mechanism used in SQl Server 2000 or 20005?

In our production environment, some of our stored procedures, views and data in our tables has changed. It would be nice to have a footprint of what was changed by whom and one.

For our code we use source safe but for SQL Server I am not aware of any type of auditing mechanism.

AFAIK, there is no built in or an add-on from MS for auditing proc or schema changes in SQL Server. Either you need to manually control the change process (via custom app or VSS) or use some third party tools.