• for DDL.

    from SSMS right click on db and select schema history changes report.

    Alex S