configuration management and version history SQL 2005

I have a Database on SQL 2005.I want to trace what all changes were made in
this database on a particular date. A kind of report that will highlight all
changes made to the DB on that date. How do I acheive that ? Please advice.
NAT (NAT@.discussions.microsoft.com) writes:
> I have a Database on SQL 2005.I want to trace what all changes were made
> in this database on a particular date. A kind of report that will
> highlight all changes made to the DB on that date. How do I acheive that
> ? Please advice.
What changes? Data? Metadata?
The default traces captures some of the metadata changes (I can't vouch
for that it captures it all). You can access this information by right-
clicking the database, select Reports and then Schema Changes History.
If the server has been restarted since that particular date, this is not
like to work out.
If you are looking for changes in data, a log reader is your sole
alternative. And only if you run with full recovery and still have
the transaction log around. Log readers are third-party tools and some
vendors are Lumigent, Log PI and ApexSQL.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Are you looking for a change control tool? If so then Embarcedaro's Change
Manager is very good
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org
Atlanta's Business Intelligence and Data Warehouse Experts
"NAT" <NAT@.discussions.microsoft.com> wrote in message
news:60C27EC6-F62F-4328-87BC-FA6BBCCC25E2@.microsoft.com...
>I have a Database on SQL 2005.I want to trace what all changes were made in
> this database on a particular date. A kind of report that will highlight
> all
> changes made to the DB on that date. How do I acheive that ? Please
> advice.