Post reply

Modification date of stored procedure

  • July 29, 2004 at 7:30 pm

    #108760

    Hi Guys,

    Is it possible in any way in SQL2000 to find out the modification date of "stored procedure" or "Function"?

    It is very urgent. Can someone help?

    Regards,

    Sandeep Bihani

     

     

     

     

  • July 29, 2004 at 7:52 pm

    #516895

    The only way you can find this is if the procedure or function was dropped and recreated.  SQL Server only stored the create date.  Otherwise, you would need to have a profiler checking ddl statements. 

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • August 2, 2004 at 3:01 pm

    #517337

    you are ture. No way to get modified date and time of stored procedure and function. But i have done some analysis and i came to know that there is no way to get modified date.

    But one of the information_schema.routines view is saying to can get the last alter date. But it showing the same create datetime.

    select ROUTINE_DEFINITION,created,LAST_ALTERED from INFORMATION_SCHEMA.ROUTINES

    Cheers,

    Dayakar Ejnavarzala(INIDA)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply