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. If stored procedure was created… Continue Reading...
Source: SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment