How To find the Changes happened to the SQL Server since last Migration

I am in a situation where I need to find the Changes happened to the database since last migration.

Eg: Changes happened to the Stored Procedure,and Views 开发者_C百科and functions.

How Can I find these Changes.

We are not using any third Party Tools.

Please can any one help me out on this.

Thanks in Advance.

Venkat

---

try this:

SELECT
    modify_date
        ,type_desc
        ,name
    FROM sys.objects
    WHERE is_ms_shipped=0
        --AND modify_date>='yyyy/mm/dd'  <--optionally put in your date here
    ORDER BY 1 DESC

---

Use a schema comparison tool like the VSDB Schema Compare (see Compare and Synchronize Database Schemas) or Red Gate's SQL Compare.

---

If you have the old version and new version installed in different SQL Server, then go to the SQL Server Management Studio, right click on your database and choose "Generate Scripts" from the Tasks menu. Choose to export the objects that you are interested in.

Do it for both and diff them.