Database change tracking software

Does anyone know of software that tracks changes to a database? For
example, it would track anytime an SP or view was recompiled, or if
you added or deleted a column to a database?"Matt Karp" <mattkarp@.hotmail.com> wrote in message
news:f23a0aff.0410140909.772fbb37@.posting.google.c om...
> Does anyone know of software that tracks changes to a database? For
> example, it would track anytime an SP or view was recompiled, or if
> you added or deleted a column to a database?

You could do that with Profiler, or there are are many third-party tools for
MSSQL monitoring.

Simon

database audit

Does MSSQL 2000 and above have an auditing feature? We have a requirement for tracking activity and history on a particular table. I realize this can be accomplished by a simple trigger but I was wondering if MSSQL had a feature that would accomplish this.
joeTriggers can record inserts, updates, and deletes, but not reads (selects).

You either need to log this activity through stored procedures used to access the data, or turn on SQL Profiler.|||Nope, you need a trigger

http://weblogs.sqlteam.com/brettk/archive/2004/10/20/2242.aspx