• There are severel ways to accomplish this :

    - using a database trigger, triggering if any DDL-Statements get fired

    - automatic scripting of your database objects to files which you compare

    - use redgate tools : SQL Compare (you can also automize it), SQL Source Control

    - there are also free tools out there

    - like I Did...write your own solution (f.e. web interface for change management, users can change nothing...database trigger forbids all DDL)

    - afaik there's a standard report named "schema changes history"

    Can't remeber more opportunities, but I know there are more. Also checkt this link[/url] and the read furthers.

    Just tell me a bit more about your special intention and I can help you better.

    Greetz
    Query Shepherd