LinkedIn | FaceBook | Twitter
We are finally out of the index reports, and we have moved on to a report that will help you track changes on your server. This report watches for schema changes, and shows you those changes after they are committed. It uses the default trace (more on that here) and watches for Dynamic Data language (DDL) statements such as “Alter” and so on.
The first band in the report groups the information by the object ID:
PingBack from http://www.biosensorab.org/2008/02/25/sql-server-management-studio-standard-reports-%e2%80%93-schema-changes-history-databasename/
Buck - I am trying to understand these reports my DDL changes was working now all of sudden it quit. I check my default trace it is turned on. Any ideas why it my stop working.
I am not sure - would have to see it to know.