Find Changes to SQL Server Database
by David Ballantyne
Problem:
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?
Solution:
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
--WHERE
--type = 'P' -- Stored Procedures
--type = 'U' -- Tables
--name LIKE '%Object Name Here%' -- Something specific
ORDER BY modify_date DESC
