SQL Server Management Studio Standard Reports – Schema Changes History: [DatabaseName]
I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, click the Standard Reports, and then select the title at the top of this post.
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:
|Object Name||The parent object name of the change|
|Type||The type of parent object|
|Created||When the parent object was created|
|Object Name||The name of the object that was changed|
|Type||The type of object (table, index, view, etc). that was changed|
|DDL Operation||The type of DDL statement that was used|
|Time||The time that the DDL statement ran|
|Login Name||The server login name of the principal that ran the DDL|
|User Name||The database login of the principal that ran the DDL statement|