Find Changes to SQL Server Database by David Ballantyne


Need to update the live database with changes made in the development database.  Not going to name names, but someone didn't document the changes.  How to get a list of the tables and stored procedures that changed?


This script lists the create and modification date of all the database objects.  Un-comment the appropriate lines if you're looking for something specific.

SELECT name, type_desc, create_date, modify_date
FROM sys.objects
--type = 'P'  -- Stored Procedures
--type = 'U' -- Tables
--name LIKE '%Object Name Here%' -- Something specific
ORDER BY modify_date DESC