SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days
I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 7 days. If SQL Server suddenly start behaving in un-expectable behavior and if stored procedure were changed recently, following script can be used to check recently modified stored procedure.…
Read More