Home Forums SQL Server 2008 SQL Server 2008 High Availability How to check stored procedure was last modified in sql server 2000 RE: How to check stored procedure was last modified in sql server 2000

  • August 9, 2011 at 3:12 am

    #1365691

    select SPECIFIC_NAME ,LAST_ALTERED from information_schema.routines

    where SPECIFIC_NAME = procname

    Jayanth Kurup[/url]