Danny Varghese: Latest Changes Made To SQL Database

[Blog bot]

Источник: http://varghesedanny.com/2011/02/21/...-sql-database/
==============

I’ve recently had to debug a stored procedure in which I remembered how the procedure functioned, but completely forgot the name.  I did know that the procedure was edited recently, so I needed to track this down somehow.  Lucky for me, there’s a quick SQL query one can run to determine all changes made to a database in the last “X” number of days:

SELECT * FROM sys.objects WHERE DATEDIFF(D,modify_date, GETDATE()) < X

You can copy/paste this query and execute, replacing the “X” with any number of days.  You can also add conditions into the query to filter on type.  For example, say you want changes only made to system tables, or changes made to functions, you can add a condition statement filtering by “type.”  Hope someone finds this as useful as I did!




Источник: http://varghesedanny.com/2011/02/21/...-sql-database/