Home Forums SQL Server 7,2000 Backups Backup stored procedures,views,user defined functions from a db RE: Backup stored procedures,views,user defined functions from a db

  • October 10, 2012 at 12:12 am

    #1547464

    You can use how to check last updated stored procedures by below queries..

    SELECT name

    FROM sys.objects

    WHERE type = 'P'

    AND DATEDIFF(D,create_date, GETDATE()) < 7

    select name,create_date,modify_date

    from sys.procedures

    order by modify_date desc