Find out most recently modified Stored Procedure and Table in SQL Server

In this post, I am sharing a script to find the modified Stored Procedure and Table for last two days in SQL Server. Using this script, DBA can easily monitor the changes of the object. Below is a script: [crayon-6a35dbc4dffac474364255/] Type P: Stored Procedure Type U: User Tables Note: I filtered DATEDIFF only for last […]

June 21, 2015 SQL Server, SQL Server DBA Script