Thursday, 8 September 2011

how to know about modified Stored procedure in database

How to see modified SP's in Database :

For SQL Server 2005 and 2008

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.objects
order by modify_date Desc

For SQL Server 2000

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sysobjects
order by modify_date Desc

No comments:

Post a Comment